I am developing an online work log database. I am using similar 'logic' to one that I created for another department that works great! The problem I am encountering is, I had my original database in Mac/FileMaker Pro. I exported the records to a text file, tab delimited and then imported (get external data) into Microsoft Access. This all went smoothly, but I am unable to search on any of the imported data. If I use the online form to create a new record, it is searchable, but still not any of the imported data. I followed the same steps from the first project, I think... what am I doing wrong???

JonShade

one more item I forgot to mention. If I do a simple query, selecting all fields from the database and use no filters or parameters, it works fine. But I need to 'complex' search and need to be able to filter based on the user's input and this is where it blows up.

JonShade