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.