how to create a receipt that has a purchace date beside items

D

d-crave

I have tabs from a store and i want to make a receipt that shows people how
much they spent for every day
 
D

Duane Hookom

Does this question have anything to do with MS Access? If so, how about
providing some background and specifications.
 
D

d-crave

Sorry I was not sepcific enough. I want to design a receipt that shows
customers their purchases for every day of one month. So I want to show them
how much they spent each day of the month. I want to enter the info into a
"table" in Access and make it into a receipt in an Access "report". My
problem is not everyone buys something everyday. So I want the dates that
have no purchases beside them to be hidden. Could you please help me set this
up in an organized way.
 
D

Duane Hookom

Take a look at the orders and order details tables in the Northwind sample
database. A simple query could easily return the sales items for any time
period.
 
Top