Adding Prices

[gregtank]

ive got a database for tickets for a school play. how can i create a query that adds up prices from multiple records? would the total be displayed in a form?

 

[ColinEssex]

use the sum function from the drop down list in the query.

Col