Summary Report with related tables

[Maureen227]

I don't know if this is a query problem or a report problem but here
it is.

I have 4 tables (invheader, equipcharge, laborcharge, payments) they
are all related to the invheader through the invoice number.
I need a report that is a summary of the equipcharge, the laborcharge
and the payments by invoice number.

I thought this would be fairly straight forward, but my problem is that
an invoice can have an equipcharge but no labor charge or a labor
charge but no equipcharge and the invoice can have payment or no
payments.

I would like my report to be like this:
Invoice# Total Equip Charge Total Labor Charge Total Paymts
100 $2,000.00 1500.00 1000.00
101 0.00 300.00 300.00
102 500.00 0.00 250.00

My query will give me all the invoices in the equipcharge table OR all
the invoices in the laborcharge OR all the invoices in the payments. I
know this is because there is no record in the laborcharge table when
there was no labor charge for an invoice and vice verser with the
equipcharge table. How do I get the query to see them all?

I will be greatly appreciative and totally impressed for help with
this.
Terabytes of thanks.
Maureen

 

[Marshall Barton]

I don't know if this is a query problem or a report problem but here
it is.

I have 4 tables (invheader, equipcharge, laborcharge, payments) they
are all related to the invheader through the invoice number.
I need a report that is a summary of the equipcharge, the laborcharge
and the payments by invoice number.

I thought this would be fairly straight forward, but my problem is that
an invoice can have an equipcharge but no labor charge or a labor
charge but no equipcharge and the invoice can have payment or no
payments.

I would like my report to be like this:
Invoice# Total Equip Charge Total Labor Charge Total Paymts
100 $2,000.00 1500.00 1000.00
101 0.00 300.00 300.00
102 500.00 0.00 250.00

My query will give me all the invoices in the equipcharge table OR all
the invoices in the laborcharge OR all the invoices in the payments. I
know this is because there is no record in the laborcharge table when
there was no labor charge for an invoice and vice verser with the
equipcharge table. How do I get the query to see them all?

I think I answered this question in another newsgroup.

Please don't post the same question multiple times. If you
feel compelled to post a question to multiple groups, post a
single message to both groups by using both groups in the To
or Newsgroups box.

 

[Maureen227]

I think I answered this question in another newsgroup.

Please don't post the same question multiple times. If you
feel compelled to post a question to multiple groups, post a
single message to both groups by using both groups in the To
or Newsgroups box.

ThanksMarsh
I am new to this group stuff I didn't know I could post to two groups
at the same time. I will do better next time.
Maureen

 

[Marshall Barton]

ThanksMarsh
I am new to this group stuff I didn't know I could post to two groups
at the same time. I will do better next time.
Maureen

No problem. Live and learn.

 

[Marshall Barton]

ThanksMarsh
I am new to this group stuff I didn't know I could post to two groups
at the same time. I will do better next time.
Maureen

Too quick with the clicks, I meant to add that you may find
this helpful in getting the most out of your newsgroup
interactions:

http://www.mvps.org/access/netiquette.htm

 

[Maureen227]

No problem. Live and learn.

Marsh
I found your post in the queries group and it was the answer to my
question or I should say my prays.. Thanks for you guidance and help.
Maureen