By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,481 Members | 979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,481 IT Pros & Developers. It's quick & easy.

CALCS

P: n/a
I'm fairly new at using Access and am lost already.......HELP! I'm
trying to create a report which I need to break down into groups,
total (count) each record per group, then determine percentages based
on data from 3 other columns -- make sense?? Can it be done?? Thanks
for any info you can give me.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Debbie wrote:
I'm fairly new at using Access and am lost already.......HELP! I'm
trying to create a report which I need to break down into groups,
total (count) each record per group, then determine percentages based
on data from 3 other columns -- make sense?? Can it be done?? Thanks
for any info you can give me.


The easiest way is to create a Totals query. Then click on
Reports/New/ReportWizard and use the query as your recordsource.

To create a totals query, create a query using the Query wizard. Select
the fields you want to display. When the query designer is presented,
look on the toolbar at the top and select the sideways M to create a
Totals query. You drag the fields down to the field row and instead of
GroupBy change to Count...or Sum...etc

An alternative method.
Click on Reports/New/Reports wizard, select your tables, and when asked
for Group On, select a field to group on. Later on you will be asked if
you want a summary report or detail report. Select Summary.

Most of the work can be done by the computer if you use the above
methods. BTW, you don't sort a report in the query. WHen the report is
in design mode click View/Sorting&Groupings.

If you run into trouble, write back. One tip. When the report is in
design mode, dbl-click on the black square where the rulers intersect to
pull up the report's property sheet. Dbl-Click on a field to pull up a
fields property sheet. If you have questions about what a property
does, move the cursor to the row in the property sheet and press the F1
key to get help.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.