you need to know or want to share it click the SQL
view when in designer mode) I can only guess at what
it might be doing.
First as you stated your common field is "Customer Id"
this means you may have to alter the queries so that
this field shows up in the end queries. From their
you can use the query designer and instead of
selecting tables you select your two queries and build
it from there.
Hope that helps
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
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.
