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
how to to round in Access?
-
- BronzeLounger
- Posts: 1272
- Joined: 01 May 2016, 09:58
-
- 4StarLounger
- Posts: 550
- Joined: 30 Jul 2014, 23:58
Re: how to to round in Access?
Here is an example
'Round to Next 1000
Somefield=[sometextbox]-[sometextbox] Mod 1000
Hope that helps.
'Round to Next 1000
Somefield=[sometextbox]-[sometextbox] Mod 1000
Hope that helps.
-
- Administrator
- Posts: 78647
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- BronzeLounger
- Posts: 1272
- Joined: 01 May 2016, 09:58
Re: how to to round in Access?
thanks a lot 250 * Round([Field] / 250, 0) this is working
-
- BronzeLounger
- Posts: 1272
- Joined: 01 May 2016, 09:58
Re: how to to round in Access?
thanks a lot for your help