Software

Ask something
Discussion Locked

Generate summary report in Access

0 helpful
5 replies

by trek05

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I want to run a summary report based on a weeks worth of data I have in the Access database. Need some help figuring it out though. Just to give a brief example of what I'm looking to do, look at this:

Monday, Jan 1st: Sold 2 apples, made $1.00
Tuesday Jan 2nd: Sold 12 apples, made $11.75
Wednesday, Jan 3rd: Sold 5 apples, made $4.95

Now, I have thousands of other records, but I want to run a report of the activity on Jan 1st to the 3rd. Again, how could I do that.

Any insight on this would greatly be appreciated.

5 replies

by sgt_shultz

create a query that prompts the user for the start and end date (see 'parameter query' in Access Help). you probably want to prompt the user for the salesperson also.
then base your report on that.
to get the total of sales for that period, create a text box in the footer of the report containing a formula that sums the relevant field in the selected records
the footer formula might look something like this :for example
=Sum([SalesAmount])

i suggest you download and play with the free Northwind Sample Database which contains reports just like you want. downloads.microsoft.com
you can copy and modify them for your own use.
If you have a licensed copy of Office you will find the Northwind sample database AND it's highly useful help files (not downloadable for free) on the second installation CD

by stevef199

Make the query a group by query.

For grouping operation put SUM for Quantity,
and GROUP BY for Date_Sold, and SUM for Sale_Amount.

In the criteria row area, under Date_Sold, put the expression as per:
BETWEEN #1/JAN/2005# AND #3/JAN/2005#

Bobs your uncle.

This discussion is closed to new replies.