rounding down to the nearest 10

[saymo]

Hi, I am quite new to access, and have the following problem:-

I have a value that is returned in a report of say 17.93, i would like to round this number down to 17, similarly 9.13 should read 0

Can someone help please? Many thanks in advance

 

[raskew]

If 17.93 rounds down to 17, wouldn't it follow that 9.13 rounds down to 9. Please clarify.

Bob

 

[saymo]

apologies....

i meant 17.93 would round down to 10

9.43 would round down to 0

if anyone could help, it would be greatly appreciated,,,,apologies for the confusion

 

[raskew]

Hi -

Would this be what you're after?

? int(17.93/10)*10
10

? int(9.13/10)*10
0

Bob

 

[saymo]

hi again, thanks for the post....

the number to be rounded down, is not a fixed value, i dont know what the value is...at least unitl it has been calculated....

so in effect i want any value that is returned by the report to be rounded down to the nearest 10....

Its for a loyalty points system, where customers that spend money in a single transaction get 1 loyalty point for every £10 spent.

So I plan to take the transaction cost and round it down to the nearest 10, then divide by 10 and I have the figure for the loyalty points per transaction.

If they spend £28 on any given day, then they get 2 loyalty points.
If they spend £31 on any given day, then they get 3 loyalty points..

Thanks again

 

[saymo]

hey...it works..

i replaced thae value (17.93) with the control source value....

superb !!

many thanks