Problem with Query after I re-link table.

[Vandelay]

Hi, I recently had trouble with a database, and so I imported the table into a new table. I go to run a query from the new table in the new database and the query stops where the old data ends. The data is based on the date, so the last date is the day I imported it. I see the new data is actually in the table and if I run the query with the logic expressions like "< 06/12/04" it will show the new data, but if I run the query with just "06/11/04" it comes up blank.

What happened, and why is this?

 

[Crowley16]

well if ur using the LIKE operator then ur doing a text comapare...

try doing the query without the condition, does the data come up then? If so, then it's a problem with your query, not the table or importing...

 

[PHV]

And what about #06/11/04# ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244