Query Question / Caluulation

[Artemis]

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

 

[namliam]

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...

 

[neileg]

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

 

[namliam]

Union

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

 

[neileg]

Who's been taking the pedantic pills today?

Yes you are quite correct.

 

[namliam]

Who's been taking the pedantic pills today?

Yes you are quite correct.

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