Multiple update and make table queries

[NLucy]

I am manipulating data in MS Access SQL and I have manipulated the data in several steps (make tables, update queries etc.). How do I combine these queries? subqueries won't work for the updates I have to do as the updates are based on several criteria and it's not recognising the IIf statement? Any thoughts?

 

[dRahme]

Hi, that is not much to go on, but if you mean running several queries conditionally from one command, you might try something like:

Private Sub cmdRunQry_Click()

docmd.setwarnings false

If YourCondition = true then

DoCmd.OpenQuery "Qry1", acViewNormal
DoCmd.OpenQuery "Qry2", acViewNormal

Else:

DoCmd.OpenQuery "Qry3", acViewNormal
DoCmd.OpenQuery "Qry4", acViewNormal

End If

docmd.setwarnings true

End Sub