Link to home
Start Free TrialLog in
Avatar of jpb12345
jpb12345

asked on

Reports and a count if function

I have a microsoft access report where  I want it to count a specific field.  The only thing is the field contains text from A thru G and I need to count how many A's, B's, C's, etc and give me a total on each letter what is the easiest way to do this
ASKER CERTIFIED SOLUTION
Avatar of JimFive
JimFive
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jpb12345
jpb12345

ASKER

IT WORKS GOOD BUT HOW CAN I COUNT IF THERE IS NOTHING IN A FIELD
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial