Query problems... (1 Viewer)

[New2SQL]

..I am trying to run a query that allows me to enter the name of an entry on my database for that entry only.

So for example, when I run the query, I am looking for information on "New2SQL" only. Now I know I could just enter this in the 'Criteria' row BUT I am needing to run this query frequently.

I know you can enter specific dates when running a query (using Format([Date],"mmm-yy") and in the 'Criteria' row putting [month mmm-yy]) which allows a month to check the data.

I need something like the above to use for Names. I hope this question makes sense and can anyone help?

 

[FoFa]

You could have your query either ASK for the information as part of the query (in the criteria use [Enter name to whatever]) or you could have your query pickup the criteria from a form (Forms!YourFormName!YourTextField) also entered in the criteria.