Run a query in a query.

I

InventoryQueryGuy

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.
 
P

pietlinden

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.
 
Top