The Member
Registered User.
- Local time
- Today, 20:27
- Joined
- Nov 2, 2001
- Messages
- 21
Dear All,
I have a report bounded to a query that has an expression called, say, Exp1. Exp1 is to be displayed in the Report.
Exp1 consists of data that are composed by two fields, say Field1 and Field2, where:
[Exp1]:[Field1]/[Field2],
but for some data sets Field2 might have a value of "0". Hence Exp1 for those entries will not be able to be calculated, in those cases the Query will display "#Err" and my report would not start.
Hence I changed the Exp1 to IIF statement where if Field2 is 0 then the cell display ":" if it is not, the calculation continues.
This makes the Query cell store two different types of data, "text" and "Numbers". Where the Text cells (ie. ":") is displaying ok, the Numberical cells now has a very large decimal place.
Anyone out there know why it is doing so, and any suggestion to help me make it back to 2 d.p. in the Report??
Many thanks
JL
I have a report bounded to a query that has an expression called, say, Exp1. Exp1 is to be displayed in the Report.
Exp1 consists of data that are composed by two fields, say Field1 and Field2, where:
[Exp1]:[Field1]/[Field2],
but for some data sets Field2 might have a value of "0". Hence Exp1 for those entries will not be able to be calculated, in those cases the Query will display "#Err" and my report would not start.
Hence I changed the Exp1 to IIF statement where if Field2 is 0 then the cell display ":" if it is not, the calculation continues.
This makes the Query cell store two different types of data, "text" and "Numbers". Where the Text cells (ie. ":") is displaying ok, the Numberical cells now has a very large decimal place.
Anyone out there know why it is doing so, and any suggestion to help me make it back to 2 d.p. in the Report??
Many thanks
JL