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.