query calculating from a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
I would have start with


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


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top