How do I sum a total of different field values?

[dvhornor]

TABLE INFO:
SkillDate / Skill / NCO
2/22/04 / 45 / 23
2/21/04 / 46 / 3
2/2/04 / 47 / 10
2/25/04 / 45 / 8
2/22/04 / 48 / 203
2/22/04 / 46 / 156
2/22/04 / 47 / 103

Query1 (Criteria Selections)
Field: SkillDate / Skill / NCO
Table: table listed above
Sort
Show
Criteria:2/22/04 / 45
or: 2/22/04 / 46
2/22/04 / 47
2/22/04 / 48

Query1 Results
SkillDate / Skill / NCO
2/22/04 / 45 / 23
2/22/04 / 46 / 156
2/22/04 / 47 / 103
2/22/04 / 48 / 203

Query2 off of Query1
SkillDate / NCO (sum)
2/22/04 / 485

Is there a way to get the results in Query2 in Query1?
Can this be done in one query?[/img]

 

[Ian Mac]

Hello,

Welcome to the board.

You can just set up 1 Query.

The following does assume that the skill is not important, it isn't in your example:

Query1 (Criteria Selections)
Field: SkillDate / NCO
Table: YourTable / YourTable
Total: Group By / Sum
Sort: Assending
Show: Tick / Tick
Criteria: 2/22/04

The 'Total' part comes from the Sigma sign on the toolbar, look like a backwards E.

Not sure if this is what is required with the limited information but it maybe a starting point.

Regards

 

[dvhornor]

Thanks for the response. Actually the skill does matter, I should have clarified. I have over a hundred different skills in my table and I need to group some of them together for several aggregate sum totals.

 

[bat17]

It may be worth either setting up a lookup table for the skills or adding another field to the skill table which will let you add a grouping clissification that you can then use to group by in your queries.

HTH

Peter