Is it possible to calculate ratio in Access?

P

Pamela

Sorry to be so short - I'm at work and I am trying to figure the ratio for
'Success to Attempt' ratio. The data in the table that I need to calculate is
as follows:
1=Yes (meaning attempt successful)
0=No (meaning attempt not successful)
The Chief wants a Success to Attempt ratio ,,,,,, and I am stumped!

Does this make ANY sense???
 
J

John Vinson

Sorry to be so short - I'm at work and I am trying to figure the ratio for
'Success to Attempt' ratio. The data in the table that I need to calculate is
as follows:
1=Yes (meaning attempt successful)
0=No (meaning attempt not successful)
The Chief wants a Success to Attempt ratio ,,,,,, and I am stumped!
Click to expand...

Do a Totals query (click the Greek Sigma button) and put into a vacant
Field cell:

Success To Attempt: Sum([fieldname]) / Count([fieldname])

This will *sum* the successes (the failures, being zero, won't add
anything) and count the non-NULL records.

John W. Vinson[MVP]
 
P

Pamela

Thank you! I will give that a try and let you know how it goes :)

John Vinson said:
Sorry to be so short - I'm at work and I am trying to figure the ratio for
'Success to Attempt' ratio. The data in the table that I need to calculate is
as follows:
1=Yes (meaning attempt successful)
0=No (meaning attempt not successful)
The Chief wants a Success to Attempt ratio ,,,,,, and I am stumped!
Click to expand...

Do a Totals query (click the Greek Sigma button) and put into a vacant
Field cell:

Success To Attempt: Sum([fieldname]) / Count([fieldname])

This will *sum* the successes (the failures, being zero, won't add
anything) and count the non-NULL records.

John W. Vinson[MVP]
Click to expand...
 
Top