report question

  • Thread starter Thread starter macamarr
  • Start date Start date
M

macamarr

Hello, I set up an access program to track daily invoices,
it works fine and so do the reports I print from it. My
problem is that my boss wants more information on the
reports and I am not sure how to make this happen. For
your information I am self taught with the help of sites
like this and the support given from its members. Thank
You!

My set up is like this...table and form
Week Of
DATE
Customer #
Sales #
Invoice #
Demand type = will call, demand delivery and sales pick up
Cases
Bottles

My report in question uses:
Week of...I group on this
Demand type ...Also group on this
Invoices
Cases
Bottles

What I need to add to the report is a break down by day of
how many cases, bottles and invoices were processed. I
would be more than happy to send a scaled down copy of my
db...
 
If I understand your description, your database already records a date (by
the way, if you fieldname is "Date", Access will be confused, as this is a
reserved word -- if so, change the fieldname to something else, say
"OrderDate", or ...).

If you want to group by a date, you can build a Totals query that groups by
that field. Use the Totals query as a source to build a new report.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top