queries

[hinser13]

Hi All I have 4 seperate queries to extract data data from 4 seperate tables, using the same criteria each time: Inspection "date" and "surveyor name" At present I have to enter the same criteria 4 times, once for each querie.

Is there a way to use the criteria once to run all 4 queries?

The 4 queries export data into a folder for and are then imported into a tablet version for field use.

Many thanks

Mark

 

[John Big Booty]

If you use a form to enter the criteria for your queries, you could base all queries on the same form, use;

Froms!YourFormName!ControlName

in your queries as criteria. You would of course need a field for each the criteria that you need in your query. If you are able to have a set of combo boxes that are each populated with a limited list of the possible selections this would ensure that your user only select valid criteria.

 

[hinser13]

Thanks for replying John.

Would I need to create a new table to control the form, with two fieilds as there are two criteria "Visit Date" & "Surveyor Name" for each of the 4 queries?

 

[hinser13]

Figured it out! thanks again John

 

[John Big Booty]

Figured it out! thanks again John

You're using an unbound form?