Data Detail in a Report

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I have a table that contains all sales history details by transaction.
I query this table to clean up items such as Customer Name, Product
Name etc.
The resulting query is an exact copy (execpt for the cleaned items)
and each record contains customer, invoice date, item etc etc.

I need a report that will basically give me a Combined Usage report
for a specific time frame and customer. I already have the form that
creates the time frame and customer criteria. I am having trouble
figuring out how to make my report show only single rows for each
item.

What I have now is a report that is properly limited but shows a
unique row for every time an item was ordered, I only want them to
show up once.

Example

Now i have

Item Number Qty Price Total
1122334455 4 0.50 2.00
1122334455 8 0.50 4.00
1122334455 2 0.50 1.00
1122334455 1 0.50 0.50
2211223344 4 1.00 4.00
2211223344 2 1.00 2.00


What I want to have is
Item Number Qty Price Total
1122334455 15 0.50 7.50
2211223344 6 1.00 6.00


I am using a form to grab the report criteria and a small script to
verify the dates and customer, apply the report criteria to the report
and open the report in print preview.
 
Change the record source of your report to a totals query that groups by
Item Number & Price and Sums Qty and Total.
 
Thanks!
I just used the same form data to limit the criteria of
the original query then used the totals query to generate
the report.
 
Back
Top