Query totals - can you help???

J

James Wilson

Hi Guys,

I have a query with 4 records in it. I want to total the records and then
generate a separate column that shows what percentage each record is of the
total.

Has anyone got any ideas on this? I'm really stumped.

Cheers,

James
 
S

S.Clark

Simple to do in a report, hard to do in a single query.

You could do it in about 3 queries, though.

Q1: Sum per category
q2: Sum overall
q3: divide q1 values by the q2 value and show the output.
 
Top