I have a query that looks like this:
The first line of code "iif" is used to check if denominator is a zero.
First - I've put the zero in quotatian marks as without them I get "data type mismatch" error. Why is that?
Second - the overall result is something like "123.123456 bp".
What I would like to do is to format this number to ignore all the numbers after decimal point, to this "123bp".
How can I do that?
Thank you!
Code:
x: IIf([qry-2008]![AC]="0";"n/m"; ( [qry-2009]![AC] / [qry-2008]![AC]-1)*100*100 & "bp" )
First - I've put the zero in quotatian marks as without them I get "data type mismatch" error. Why is that?
Second - the overall result is something like "123.123456 bp".
What I would like to do is to format this number to ignore all the numbers after decimal point, to this "123bp".
How can I do that?
Thank you!
Comment