Lost Hours on Report Format

  • Thread starter Thread starter lljpdx
  • Start date Start date
L

lljpdx

I need a report to show:
First column: Vendor Name
2nd column: Each product the vendor supplies
3rd column: $ Totals of accrual total for each product type listed in Col. #1
4th column: $ Totals for current billables for each product......
5th column: $ Totals for Non-consignment/prepaid for each product.....
6th column: $ Product type total

Each of these Amts/Totals is a calculation in a seperate query. Before I
try further, are subreports the answer to this type of "table"? Is so, I'll
have to make each seperate report format the same so they line up on the main
report, creating the column/row appearance?

Any help is appreciated!!
 
There is another way than subreports.
First create a totals query to produce a complete list of Vendors by Vendor
Name.
Put that query in another query and left join it to all of the other queries
you created for your totals. To make a left join, in query design view click
on the Vendor Name field in the totals query and drag to the Vendor Name in
the other query you are using. Double click on the connecting line and
select "Include ALL records from 'FirstQuery' and only those records from
'SecondQuery' where the joined fields are equal."
Do the same for the other queries.
 
Thank you so much! I've been toiling over this, nothing was working. I've
got all the totals, I just couldn't get them together!

I'll try this.
 
Back
Top