Numbers

  • Thread starter Thread starter rokjock
  • Start date Start date
R

rokjock

I have created a field in my database call "Credentials". This field
contains all forms of credentials including PHD, MSN, MA,MBA, etc..... I
would like to query this field to find out how many PHD's are listed. I
would like for this to be in numerical format so that I may turn it into a
percentage. Does anyone know how I would begin to accomplish this. I have
limited knowledge regarding access but I am learning quickly. Thank you
very much in advance!
 
rokjock said:
I have created a field in my database call "Credentials". This field
contains all forms of credentials including PHD, MSN, MA,MBA, etc..... I
would like to query this field to find out how many PHD's are listed. I
would like for this to be in numerical format so that I may turn it into a
percentage. Does anyone know how I would begin to accomplish this. I have
limited knowledge regarding access but I am learning quickly. Thank you
very much in advance!

A simple way would be to create a report and group on the field that
Click to expand...
contains PHD etc, then add a footer to the detail row in the report and add
a formula like =Count([field name])

Bruce
 
sounds good Bruce! I will give a shot. Thank you very much!
Bruce said:
rokjock said:
I have created a field in my database call "Credentials". This field
contains all forms of credentials including PHD, MSN, MA,MBA, etc.....
I
would like to query this field to find out how many PHD's are listed. I
would like for this to be in numerical format so that I may turn it into
a
percentage. Does anyone know how I would begin to accomplish this. I have
limited knowledge regarding access but I am learning quickly. Thank you
very much in advance!

A simple way would be to create a report and group on the field that
Click to expand...
contains PHD etc, then add a footer to the detail row in the report and
add
a formula like =Count([field name])

Bruce
Click to expand...
 
Back
Top