How to run a loop of queries in access?
- by tksy
Hi
I have a database with a table which is full of conditions and error messages for checking another database.
I want to run a loop such that each of these conditions is checked against all the tables in the second database and generae a report which gives the errors.
Is this possible in ms access.
For example,
querycrit table
id query error
1 speed<25 and speed>56 speed above limit
2 dist<56 or dist >78 dist within limit
I have more than 400 queries like this of different variables.
THe table against which I am running the queries is
records table
id speed dist accce decele aaa bbb ccc
1 33 34 44 33 33 33 33
2 45 44 55 55 55 22 23
regards
ttk