formatting calculated field

Question

on a form i have a field that is calculated in a query

formatting = #

but it gives a 0  in stead of blanks...

what is wrong

Answer 1

but it gives a 0  in stead of blanks...

Hi tekoko10,

What is the result of the calculation just before the formatting? Probably 0.

Imb.

Answer 2

yes , it is  0

Answer 3

yes , it is  0

Hi tekoko10,

You could use the IIf function to return a Null- or ZLS-value in case the calculation = 0, else the formatted value.

Imb.

Answer 4

Hello tekoko10,

What's the state of the thread? Is your original issue resolved? If it is, I would suggest you mark ANY helpful reply to close the thread. If not, please feel free to let us know your current issue.

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].