how to to round in Access?

[siamandm]

Hello all,
I have a question about rounding numbers in access.

10800 become 10750 and make 8900 becomes 9000
so basically all the number should have a format like
250
500
750
1000
1250
1500
1750
2000
2250
and so on

Regards

[burrina]

Here is an example
'Round to Next 1000

Somefield=[sometextbox]-[sometextbox] Mod 1000

Hope that helps.

[HansV]

Use

250 * Round([Field] / 250, 0)

[siamandm]

thanks a lot 250 * Round([Field] / 250, 0) this is working

[siamandm]

Here is an example
'Round to Next 1000

Somefield=[sometextbox]-[sometextbox] Mod 1000

Hope that helps.

thanks a lot for your help