This has me stumped so far - I need to round up to the nearest nickel, preferably in a query. Have figured out how to round to the nearest nickel, but cannot get it to round up.
I round to the nearest nickel like this:
RoundedNumber: Round(20*[MyField],0)/20
Any ideas?
I round to the nearest nickel like this:
RoundedNumber: Round(20*[MyField],0)/20
Any ideas?