How to design expression in MS Access Table

[Michelle Arceneaux]

Thank you in advance for helping someone very new to Access and VBA.

I have a table that has been used in my department for years and strikes me as a little inefficient in terms of the details it provides. The data details ticket accounts and so far I have had to manually figure out how many tickets each account has left. I would like to employ a code that will automatically perform this function and display the balance in the table. The table fields read as follows:

Field1 = PaymentTicketsIssued (ComboBox--Payment or TicketsIssued)
Field2 = Type of Ticket (ComboBox--Adult or Child)
Field3 = Tickets Issued (Quantity of tickets issued)
Field4 = AdultPurchased (Quantity Purchased)
Field5 = ChildPurchased (Quantity Purchased)
Field6 = AdultRemaining (Quantity left)
Field7 = Child Remaining (Quantity left)

The code needs to:

• Identify when and how many Adult and Child tickets are issued, respectively.
• Subtract AdultPurchased/ChildPurchased from Adult/Child TicketsIssued respectively.
• Display the corresponding balance in the AdultRemaining/ChildRemaining fields.

Thank you again for any assistance you can offer!