basic query help - SUM

[beekay22]

Hi guys,

Im trying to get my Access 2000 query to return a number of rows based on certain criteria. This is no problem.

Each row contains a field with a value that id like the query to eventually total up at the end, but also to include the original rows that it returned...

is this possible??? ive tried using the help function, but cant seem to find the command that i want!

kind regards

\Beekay

 

[Crowley16]

there's not direct way of doing this...

either you have to do the summing on the report, or use a union query to "append" the sum to the end of the original query...

personally, I'd do it on the report, that's what it's for...

--------------------
Procrastinate Now!

 

[beekay22]

cheers crowley, id already started to think about this!

kind regards

biren