Query to perform percentage

[mari_hitz]

Hi everybody!

I have a little issue with a query I would like to perform: I have a table with a group of people to which I should send two types of communications, there is a Column that indicates if the person should receive the first communication or the second . I have managed to make a "Count" that returns me how many persons should receive the first communications and how many the second.
However, what I am looking for is to create a report or a table that can return me how many persons should receive the first communications and the percentage, and so on, like the table below.

	First Communications	%	Second Communications	%
Business travelers	3	43%	7	44%
Complex Cases	4	57%	9	56%
Total	7	100%	16	100%

I have tried to obtain the percentages based on examples found in the web, however the query returns me error, and I guess it is because I do not have numbers, I have comments that should be counted. I am not looking for the exact table of above, I will be more than happy to get the percentage hehe.

Thanks in advanced!

[June7]

Don't try to calculate percentage in query. Use report Grouping & Sorting with calcs. Do a Sum calc in textbox of report header or footer and refer to that textbox for the percentage calc in the Detail section.

[mari_hitz]

Don't try to calculate percentage in query. Use report Grouping & Sorting with calcs. Do a Sum calc in textbox of report header or footer and refer to that textbox for the percentage calc in the Detail section.

Thanks June for your help! Sorry for my ignorance but my knowledge of Access is pretty basic. You say I should indicate in the textboxes to perform the calculations, how do I do that? I should assign a macro to it? Sorry but again my knowledge is limited.

Thanks

[June7]

Is the report RecordSource based on a GROUP BY (totals) query?

You need the total for each First and Second. Textboxes in footer with ControlSource expressions:
=Sum([First fieldname])
=Sum([Second fieldname])

Give textboxes meaningful names like, tbxFirstTot and tbxSecondTot.

Then ControlSource expression for textboxes in Detail section:
=[First fieldname]/tbxFirstTot
=[Second fieldname]/tbxSecondTot

Do you want to provide the project for analysis?

Calculations in textboxes on reports (or on forms) is basic Access functionality and guidelines in Access Help.

[alansidman]

Cross Post

http://www.access-programmers.co.uk/...d.php?t=224342