Microsoft Access Calculated Field - Division By Zero 1

[LevelThought]

Currently, I have a calculated field in a Access query as follows:

Ratio: "Encounter.Expected_Reimbursement/Encounter.Total_Payments" that continues to return an error titled "Division By Zero." I would like to see the results displayed in the percentage format.

I formatted the column as "Percent" but the error still is displayed!

What am I overlooking? Any assistance is appreciated.

Thanks in advance.

 

[PHV]

Seems that you have records with Total_Payments=0 ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[earthandfire]

You could try something like:

IIf(Encounter.Total_Payments=0, 0, Encounter.Expected_Reimbursement/Encounter.Total_Payments)

Hope this helps.

 

[LevelThought]

earthandfire,

where would this statement go?