Help with expression in MS Access Subform

[Michelle Arceneaux]

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

I have a database 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!

[jimatqsi]

It's not very clear what you want. Do you want to add some columns to the database table? Or are you describing a form you would like to have?

I think what you really want is to make a query with the query wizard, then you can run the query and see virtual columns showing the computed values.

You say " The table fields read as follows" but it looks like you are telling about form objects, not the table definition. Combo boxes are form objects, not part of a table definition.

What is the name of the table(s) this stuff is in and what are the elements? I don't see an account number/identifier listed, but I think you will want to group by that.

Also, you say "identify when", but there is no date/time data item. What do you mean by that?

Try making a new query based on the table with your ticket information. Start off by using the new query wizard - it can automatically group for you and compute sums, averages and some other nifty things. When that is done, take a look at the query in design mode to see how the query works. You'll learn a lot from that. Just double-click on the query name to see the resulting data.

Then come back with more details and questions :)

Jim