How can I calc percentages based on two fields from a query

[Bomber]

I have created a DB in access 2003, but now need to calculate the percentages
from two fields. One field is for course type and the other is for
designation(Nurse, Doctor etc). I need to be able to print a report that
shows how many Doctors have completed each type of course. Is there anyway of
doing this

 

[Aaron G]

Bomber,

Sure, you can do this. Your description of what you want is a little hazy
though to provide an exact solution.

You say you want to calculate percentages from two fields. You then say you
need to show how many doctors have completed each course. Do you need a flat
number (ie. 16 doctors) for this second question or is this where you want to
see a percentage (ie. 37% of all doctors)?

Since I can't be more specific, here are a few things you can look into that
may help you.

Try the dsum function. You can use this in VB. You may also want to use
the GROUP BY function which is SQL.

Give us some more details so we can help you further.

Aaron G
Philadelphia, PA