How to get Total ordered for week by Fish.

[abzalali]

Dear Expert,
I need a report that show Total ordered for week by Fish for a single customer. I have customer table and OrderDetals table with order date. Shipping date Monday to Friday. When preview the report the it shows the current week Total order quantity for each fish for single customer. How do I get this.

Please anybody help me.

Thanks in Advance
Mir

 

[Geotch]

use the Grouping function in the report, or Totals button in the queries.

Can you upload some sample data, it's faster to create the query/report than to type it
out.

 

[abzalali]

Thanks Sir,
I found solution finally.