Help with multiple tables

[Cortney]

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?

 

[John Nurick]

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.

 

[Cortney]

Thanks, I appreciate your help.

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.