Calculating Sales Ticket Reports including Taxable and Non Taxable items

[MacMan]

l created a Access Database for our Holiday Bazar this last year. However we had to manually back out some of the sales as they were items that were non-taxable in our state. The fields for the DB are: ID(primary Key), Ticket Number (Sales Slip), consignor #, Quantity, Unit Price, Unit Total and a check box to indicate that the item was Non-Taxable.



I need to create a summary report that will show by the Ticket Number the Totals for the Taxable items, Non-Taxable items, Tax and Total for the ticket.

I think this may require some VB coding and I have been out of that world for a long time. Any help greatly appreciated.

I am running Office Pro 2013 under windows 10.

If this belongs in a different forum please advise.

[ssanfu]

I would recommend NOT use spaces in object names.
Object names should only be letters, numbers and/or the underscore. NO punctuation or special characters!

Would you post your dB with a few example (fake) records? Do a "Compact & Repair", then Zip it.

Is there a sales date field in the table?

In the summary report, there would be one line for each ticket number?

[MacMan]

I would recommend NOT use spaces in object names.
Object names should only be letters, numbers and/or the underscore. NO punctuation or special characters!

Would you post your dB with a few example (fake) records? Do a "Compact & Repair", then Zip it.

Is there a sales date field in the table?

In the summary report, there would be one line for each ticket number?

The object names you can see are what I originally set up. I added a check box to note that the item being sold is non-taxable.
There is no Sales date in the database as the sale is only once a year on Friday and Saturday.
I would like the summary report to show ticket number, Sub Total of all items, Sub Total for Taxable Items, Sub Total for Non-taxable items, Tax (.087) and Grand total.

then a total of all of the columns at the bottom of the report

[ssanfu]

There was no check box for taxable/non-taxable in any table...

I made a few changes.

Is this close to what you had in mind?

[MacMan]

Steve, Sorry for not getting back to you sooner. We have been in the process of moving and travel for the Holidays.

I cleaned up much of the database and have built a model of the report that I am trying to figure out the rest of the information. I also redid the InputFile having a separate column for NON-Tax items and NT-Total. The purpose of this report is to validate that the tickets that the clerks had write match the report, and to provide a final tax due figure.

I have attached the report that I have worked on. It is HM_DEV.addcb.zip. The report is Ticket Detail Report. In the TicketNo Footer I want the Tax text box to =the sum unit total * .087 and then the Ticket total with tax to = Sum unit total + tax.

Then at the bottom of the report I want to add in the total tax due.

HM_DEV.accdb.zip