Run a query in a query.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If i have a query called SunQuery, how can I run it in an if statement, for
example.

if T.Min>T.Inventory then run query.


Thanks.
 
InventoryQueryGuy said:
If i have a query called SunQuery, how can I run it in an if statement, for
example.

if T.Min>T.Inventory then run query.


Thanks.
Click to expand...

You'd have to open a recordset based on the first query or use DMin()
in your If statement. Even so, you can't run one query from within
another. You could do it in a macro or code, though.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Please!! Putting together a Challenging Query 2
If, then, Insert date, else. 3
update only using last record. 3
Update specific record based on max date and max time. 1
addition from one table to another. 1
Can you spot the Syntax error?? 3
Parameter Query Won't Run 0
Combine Duplicates in Query 0

Back
Top