Problems with totals

[marksnwv]

In my Table I have field names called NumRec, NumWkd and BacklogWkd. They stand for Number Recieved, Number Worked and Backlog Worked.

My query has a calculated field that says Backlog:Sum([NumRec]-[NumWkd]). This calculated field works fine.

I need a second calculated field I call TotalBacklog. This field needs to take the answer from Backog and subtract BacklogWkd to give me my remaining totalBacklog.

I have tried many different combonations without success.



The pc I am using is running XP and access 2002

Help!

[June7]

The Sum is an aggregate function so this must be a totals query. Instead of doing the aggregate calcs in query, consider building a report for this. Use the report Grouping & Sorting with summary calcs to present this data manipulation.

[marksnwv]

Thank you. Your recomendation worked and I have marked the thread resolved.