Nov 29 2004, 09:35 AM
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?
Nov 29 2004, 09:53 AM
so, if you type in Adam instead of ADam , is not working ?
Nov 29 2004, 10:06 AM
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?
Nov 29 2004, 10:12 AM
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.
Nov 29 2004, 10:14 AM
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!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here