Should be easy..

[Kiwigirl1]

Ok so I have made a query..and have 3 fields seniors,Juniors and Novices. I need to know how many have over 100 members including all 3 fields. I thought my formula was along the lines of Seniors+Juniors+Novice but then unsure where to put the >100

Also unrelated to this....when I sort a field into Asserting how can I do all my fields at the same time so all the data collates?

Thanks in advance!

 

[Kiwigirl1]

Im using Acess2013

 

[pwbrown]

Should be something like:

SELECT Table1.Seniors, Table1.Juniors, Table1.Novices, [Seniors]+[Juniors]+[Novices] AS Total
FROM Table1
WHERE ((([Seniors]+[Juniors]+[Novices])>100));

Change Table1 to your table name - highlighted in red
If you don't want to include the total in the results table remove the blue text.