Peter Bellamy
Registered User.
- Local time
- Today, 17:43
- Joined
- Dec 3, 2005
- Messages
- 295
If a query is based on two other queries, how is that actioned in vba using SQL?
SQLqry1 = "SELECT....."
SQLqry2 = "SELECT...."
SQLQty3 = ?? (Selecting all the of results of SQLqry1 and SQLqry2)
DoCmd.OpenQuery SQLQry3
Thanks
SQLqry1 = "SELECT....."
SQLqry2 = "SELECT...."
SQLQty3 = ?? (Selecting all the of results of SQLqry1 and SQLqry2)
DoCmd.OpenQuery SQLQry3
Thanks