Hello, I am building a database for a barber shop. Not too complicated and it's coming along well. I have an unbound form that has option buttons for user to select types of haircuts, prices, and payment methods. After all fields are populated, user clicks cmdSubmit button. This runs an Insert Into query and stores all data in my tblHaircuts. At the end of the day, after the last haircut is done, I want to run an "End of Day" function that will take the total amount of money brought in for that day and insert a line into my tblLedger for financial reports. I know I need to run a query to get the total of that day and I have that, qryDailyTotals. This brings back the total sales grouped by day. I need to get that total into the tblLedger, do I need to dim a record set? Or do I just need to run an Insert Into query? If I do that, how do I insert the total amount the qryDailyTotals is pulling back into the tblLedger? Any and all help would be greatly appreciated! Thank you, Dannie.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.