Using DSum in Query

[jlcford]

I have a Query with 2 fields. The first field has Record_Order_No with multiple identical entries. The field is text data. The second field has the Cost of each Record_Order_No which is currency data.

I want to be able to sum each Record_Order_No costs and output it to another table or Ouery with two fields - the first field being labeled Invoice_No (but it will be the same number as the Record_Order_No) and the second field being the Total Sum of the Costs for that Invoice_No.

Thank you for your help.

jlcford

 

[pbaldy]

How about a query:

SELECT Record_Order_No, Sum(CostFieldName) As TotalCost
FROM TableName
GROUP BY Record_Order_No

 

[jlcford]

When I do that it prompts me to enter the individual Record_Order_No. I don't want an individual record count, I want a new table or query output of all the records sums as my output.

Thats were I am running into the problem.

jlcford

 

[pbaldy]

If it's prompting for anything, the field name is spelled wrong. That should output each record order number and its total (one line per order number).

 

[jlcford]

Thx - It worked.

jlcford