C
Charyn
Good afternoon,
I am new to Access and have a tool that contains a report linked to a single
query. The items in the data are sorted by type and by class. I only want
one class to print on the report, but I want to also report to type total as
a percentage of the whole.
For example, if the total records are 100 and I have 10 records of type A in
class B (which has 50 records), I would want the % to total to reflect 10%,
not 20%
If I filter using criteria in the query, I get a % to toal of 20%
Any suggestions how I can only show the class that I want without
sacrificing the grand total?
Thanks!!
I am new to Access and have a tool that contains a report linked to a single
query. The items in the data are sorted by type and by class. I only want
one class to print on the report, but I want to also report to type total as
a percentage of the whole.
For example, if the total records are 100 and I have 10 records of type A in
class B (which has 50 records), I would want the % to total to reflect 10%,
not 20%
If I filter using criteria in the query, I get a % to toal of 20%
Any suggestions how I can only show the class that I want without
sacrificing the grand total?
Thanks!!