counting calculations

[chrisl]

I am new with access and need a bit of help with a report. Is there a way to count 2 different values within a field and then divide it by the total number of records in the report (which is generated by another field) so that a percentage may be obtained?
Any help is appreciated.

 

[charityg]

Why are you storing two different values in the same field????? Big no no.

If the values were in two separate fields, you can use a query to define a field as

Avg1:Sum(field1)/Count(ID)

Avg2:Sum(field2)/Count(ID)

 

[chrisl]

Thank you for the feedback Charity. The field is a drop down menu with 4 different values to choose from. Is this bad design?

 

[chrisl]

Pat,

I really appreciate your reply. I will give your suggestion a try and let you know how it goes.

Thank you,
christine

[This message has been edited by chrisl (edited 11-09-2001).]