Table type report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Each record in my database contains a date, a $ amount and a product code.

I want to produce a table type report that summaries the $ amount by month
in columns Jan to Dec in one horizontal line (with a grand total) and by
product code in rows (with a grant total that cross casts). Any ideas? Many
thanks.
 
Sounds like you want a Cross-tab query. Open a new query, select Cross-tab
and let the wizard walk you through it. Then, once you've got the query, use
it to form your report.
 
Many thanks Doug
--
Peter
London, UK


Douglas J. Steele said:
Sounds like you want a Cross-tab query. Open a new query, select Cross-tab
and let the wizard walk you through it. Then, once you've got the query, use
it to form your report.
Click to expand...
 
Back
Top