SUM Multiple fields in a query

[Thoudus]

Hi all,

First of all sorry if this has already been adressed elsewhere.



I'm a begginer in access.

I have a query with multiple fields that I want to sum based on criteria. For example, I want to sum 10 fields but only if the value is "1". Then I want to sum the same fields but only if the value is "2"...

Can anybody help me?

Thank you

[Rixxe]

SELECT SUM(*)
FROM Table1
WHERE Field1 = '1'
OR
WHERE * = '1'

Think you can use * in a where clause, if not name the table 'AS a', then use a.*.
Is that what you want?

Good Luck.

Rixxe

[Thoudus]

Thank you Rixxe,

But besides Field1, the other fields also have to be = 1. Otherwise I want to discard them from the SUM.

Am I missing something?

Sorry if I'm messing up

[Rixxe]

Sorry should have mentioned:

If you want to add the criteria to ALL fields (So all fields = 1)
Then this is the best bet:

SELECT SUM(*)
FROM Table1 AS a
WHERE a.* = '1'