Hey,
So i have these two fields. Ticket Type and Quantity. This is for a database regarding concert ticket sales.
What i need, is for the database to automatically multiply these two fields together, of which the resulting value is to appear in another field, "Ticket Cost".
However, The Ticket Type field quantities vary.
there are 3 tickets, Adult, Child/Concession and Pensioner.
Adult = $25
Child/Concession = $15
Pensioner = $12
ie// Adult ( $25) * Quantity ( 2 ) = Ticket Cost ( $50 )
I'm new-ish to MS Access, so itd be great if you could be me with my troubles =S
So i have these two fields. Ticket Type and Quantity. This is for a database regarding concert ticket sales.
What i need, is for the database to automatically multiply these two fields together, of which the resulting value is to appear in another field, "Ticket Cost".
However, The Ticket Type field quantities vary.
there are 3 tickets, Adult, Child/Concession and Pensioner.
Adult = $25
Child/Concession = $15
Pensioner = $12
ie// Adult ( $25) * Quantity ( 2 ) = Ticket Cost ( $50 )
I'm new-ish to MS Access, so itd be great if you could be me with my troubles =S