query calculating from a table

[Guest]

Hey i have a table which contains new orders information includes date,
model, quantity, cost , total cost. I need some way of calculating and
displaying the total quantities for the different models in my form. im
really stomped

thanks in advance

 

[Michel Walsh]

I would have start with


SELECT model, SUM(quantity)
FROM tableName
GROUP BY model


Hoping it may help,
Vanderghast, Access MVP