Hello,
We operate a food concession as a fund raiser once a year for a benefit.
I wish to have the cashier at the food concession check customres out with a form screen that contains each food item ( Hamburger), a left and right arrow button for incrementing and decrementing the number purchaesed, a calculation text field next to it with the subtotal of hamburgers purchased.
The amount is calculated, the money exchanged, and change is given.
The =Now is used to stamp the transaction.
How do I get all of these fields into a table so at the end of the day, we have a tally of all the purchases? From this table I want to build a query to extract how many of each item sold, and also get the total amount of each item sold so next year we know how much of that item to buy.
In summary - the cashier form transacts all purchases, and a table needs to store all the days transactions so queries can be run on the data. All calculated subvalues and such need to go from the form to the table.
thanks
bob
bob
We operate a food concession as a fund raiser once a year for a benefit.
I wish to have the cashier at the food concession check customres out with a form screen that contains each food item ( Hamburger), a left and right arrow button for incrementing and decrementing the number purchaesed, a calculation text field next to it with the subtotal of hamburgers purchased.
The amount is calculated, the money exchanged, and change is given.
The =Now is used to stamp the transaction.
How do I get all of these fields into a table so at the end of the day, we have a tally of all the purchases? From this table I want to build a query to extract how many of each item sold, and also get the total amount of each item sold so next year we know how much of that item to buy.
In summary - the cashier form transacts all purchases, and a table needs to store all the days transactions so queries can be run on the data. All calculated subvalues and such need to go from the form to the table.
thanks
bob
bob
