G Guest Aug 24, 2006 #1 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.
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 Aug 24, 2006 #2 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.
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.
