No need to know SQL except for more complex items, like, for example, union
queries.
Just use the Query wizard in Access, and instead of dragging tables into the
query wizard, drag the other 2 queries in.
Richard "Manxman" Killey
MS Access Developer
for more MS Access tips, visit
http://www.accessdatabasetips.com
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] Behalf Of Adam
Sent: May 30, 2006 5:39 PM
To: [email protected]
Subject: [Access VBA Central] Using Queries instead of tables in a query
Hi! I have two queries setup, one that totals international revenue
via a la carte orders and another query that totals international
revenue by packages ordered. i would then like to create another query
that uses both those queries to give me international revenue. i'm not
too familiar with SQL (only use the designer for queries). can anyone
help? The common field in these would be a customer ID, but only the
customer alias shows up in those two queries for international
revenue.
thank you!
Adam
Yahoo! Groups Links
SPONSORED LINKS
| Microsoft access database | Database development software | Microsoft access development |
| Database management software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "AccessVBACentral" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
