Hi there,
I’m new here on the forum and on Access and facing a problem that’s look like impossible for mes.
I work for a restaurant and every day the waiter staff generates quite a few paper “guest check”. These checks have:
Check number (#####)
Date (LONG)
Time
Server (Server 1, Server2, …)
Table (01, 02, 03,…)
Payment method (CASH, VISA, MC, AMEX, GIFT CERTIFICATE, OTHER)
Discount (0% - 100%)
Item Quantity
Item
Unit Price
Sub total (before tax)
Total (after tax)
So, I have all this data in excel but I really can’t do what I need.
I need to be able to:
Generate reports with the most sold items by date (day / month / period)
Find the totals for each waiter/waitress (Server)
Generate the totals for the day / month / period
I’m reading MS Access 2007 Bible about normalization and I still cant understand the best way to design my tables and forms.
My first challenge is “how can I have one line in my table AND in the form for a ticket with many items?”
Attached is a practical example of the data we collect
Notice we are using many rows for the same ticket, repeating date, time, table, server, discount and payment method!
The fields for subtotal are calculated ([Item Quantity*Unit Price]-[discount]) and the total (Subtotal+TAX).
Also, we are not getting the total for the ticket!
Please, any help is really welcomed!
Best regards