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