making totals of all, except for one

stef123

Registered User.
Local time
Today, 15:33
Joined
Sep 12, 2005
Messages
11
I'm trying to make totals in a query, but instead of using all, I need to leave one out, how to do that? for example the table looks like:
A 2 3
B 4 6
C 2 5
D 3 5
E 2 3
How can I leave row 1 out? So that the query will look like:
11 19
 
Add a criteria to the query that excludes that record, like

WHERE FieldName <> "A"
 
pbaldy thanks, it worked perfectly
 

Users who are viewing this thread

Back
Top Bottom