Hi

This is simple I am sure but am not functioning very well!
I have a basic query that finds Dates attached to Various Names
The problem is for my query criteria I have - Like [Enter Name]
This then prompts you for data
Works fine if you get the name spot on. The problem is the dbase holds some Names like ADam and jOe - they are MEANT to be like that - but sadly the query fails if its not correct - any ideas?

Cheers

LQ

so, if you type in Adam instead of ADam , is not working ?

Well things are getting strange....

I investigated a little more - the tables are OK - entering information in forms is fine. But it seems the query is not looking at the new records entered. If I put a * in the prompt it shows me the records - all but the new ones I entered. I have tried shutdown the dbase and compact and repairing it - the tables and the forms (they get data from tables) show that new data is in. Am at a loss to understand why the query will not pick up the new records........ surely it gets refreshed everytime it runs?

I assume you are entering some spaces at the end of the record.
Try using Trim function ( so instead of selecting the FiledName in your query, use Trim([FieldName]) and same Like [Enter Name] in criteria.

Well .... wierd I got upset with it called it names, and it sorted itself out - did not change anything.

And the query is now ignoring Caps - thats sorts my problem out too!