I have crated a small database which produces a query (see attached excel file) I want to be able to add up all the 1's at the end of the column. I'm sure there must be and expression to fit the bill however I have know idea where to start.

I am also trying to find either in Access or on the internet somewhere that gives a full list of expressions and their explanations.


Any help grately appreciated.

Artemis:)

Try hitting F1 for help...

And for your solution to your question, look into the help for a "Group by" query... that does what you want...

You can't use one query to produce two different totals. You'll need two queries, one for ReceivedBy and one for TechSupportName.

Union

If you use a union you can... tho technicaly it is two queries... ;)

Who's been taking the pedantic pills today?

Yes you are quite correct. :D

Who's been taking the pedantic pills today?

Yes you are quite correct. :D

I dont know what the doctor is giving me.... I find them on my breakfast slab when I get up in the morning :rolleyes: