fixed format numbers required from a list

[Mohamed Gani]

Hi All,

I am very beginner to MS Access. I have a table which contains list of data like,
10025.325
100.245
1245.8464
12546.356
etc.. etc.....
Now, I need a data which contains numbers 5 digits before decimal point & 3 digits after decimal point.

like xxxxx.xxx

Your idea will be much useful for me....

Regards,
Mohamed Gani.

 

[billmeye]

Here is a way to do so:

DigitsBeforeDecimal = CInt(12345.345)
DigitsAfterDecimal = Right(1234.434,Instr(12345.345,".")-2)

 

[Mohamed Gani]

Hi ,

Thanks for the response.

Is it possible to do the same by using query ?

Regards,
Gani.

 

[billmeye]

Yes, it works the same.

 

[billmeye]

Thanks Pat.