Help with multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with 4 tables. The first is a customer list. The second
is an A/R aging table with a month field, and the last two include
ttransactions. Each table has a date field (by Month) except the customer
list. Not all customers will have an entry on each table. I am having
problems querying all the tables together because to get a big picture of the
customers because it is confusing the dates. For example, if a customer has
an entry for Sep but not Oct, the query is putting Sep entry into the October
field to fill it, I guess. Right now I am using a form with two subforms but
I can't get them to print the right output, it only prints the main form.
Can anyone help me?
 
Hi Cortney,

This newsgroup is for problems using Access to manage external data.

If you're having problems working out how to join your tables in a query
to get the results you need, ask in the Access Queries newsgroup
(microsoft.public.access.queries) - but give more information about the
fields in your tables and how they are related.

If the problem is with printed output, use a report and sub-reports:
reports are designed for printing while forms are not.
 
Thanks, I appreciate your help.

John Nurick said:
Hi Cortney,

This newsgroup is for problems using Access to manage external data.

If you're having problems working out how to join your tables in a query
to get the results you need, ask in the Access Queries newsgroup
(microsoft.public.access.queries) - but give more information about the
fields in your tables and how they are related.

If the problem is with printed output, use a report and sub-reports:
reports are designed for printing while forms are not.
Click to expand...
 
Back
Top