Daily Sales Report

[bayswatergirl]

I am new to database and have been trying to create a database to track sales.



I am now trying to create a report that will easily give me what my daily sales are and the totals for paid by cash, visa, debit, mastercard.

I have been searching on how to do this and havent' come up with much. I'm wondering if someone would be able to direct me on where to start?

Thank you in advance.

[alansidman]

Probalby the easiest way is to first build your table with appropriate fields making sure to observe normalization rules. Next, build a query containing the fields you want information on. Convert this query to an aggregate query and use this query as the record source for your report.

Have you built your table? If so, what does it look like? List your fields and data type.
Alan