Qry Sum By Age and a few criteria's

[Jordan2000]

I got a dataset and I am genarating a report.
I need the sum of a qry <3 years and 4 years 5 years and older than >12 years
But it is kind of dificult to put this in 1 qry.

Is it posible to make that kind of Qry in Access ??

Data is like

Years v1 v2 ....
0 32 45
1 12 42
5 53 54
9 46 90
..
..

need the sum of < 3 years and >12

Hope that someone can help me with thise one

 

[Brianwarnock]

Hi
Wasn't clear as to whether you wanted individual sums within the criteria or sums of all <3 and all>12.
Easier to do than explain
Attached document shows both qbe and sql for both options

Brian