Query totals - can you help???

  • Thread starter Thread starter James Wilson
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Aggregate Function Error 0
Access Dcount (multiple criteria) 3
Excel Subtracting multiple columns from another column 3
Running Total in Query (Access 2003) 4
Crosstab query help 1
field Null but not Null 9
How to multiply percentages in a CROSSTAB-action 1
DSum in Queries 3

Back
Top