Currentcy Calculation

[ATB]

Is it possible for me to round up a calculated curency field in a query to the nearest 49p or 99p. Example £2.57 becomes £2.99.

Thanks.

 

[Alexandre]

Say that, in your query, the field holding your currency result is named X
Then add in a new column of the QBE grid, in the firts line:

RoundedResult : iif(((X-int(X))* 10 \ 5) = 0, int(X) + 0.49, int X + 0.99)

Alex

[This message has been edited by Alexandre (edited 02-01-2002).]

 

[KKilfoil]

or

roundup = (int(x*2)/2+0.49)

 

[Alexandre]

? Kkilfoil
I don t seem to have a roundup function in A2K?

Alex

 

[ATB]

Cheers Alex. The code work well.

ATB

 

[KKilfoil]

Alexandre:

Roundup was my fieldname! (I left out the ':' in my defn)

 

[Alexandre]

:0