RETRIEVING PORTION OF STRING

[hnunez4399]

Hello I have a query that runs and does some calculation.
I do not want it round up. But at the same time I want to be able to take the whole number of that field from the decimal point. what would be the best way to do this.
Thanks,

 

[KenReay]

Hi

See Fix() function and/or CInt() function and/or Int() function, each bahaves stightly dirrently in terms of what they do with the decimal places, see which one does what you want (if any)

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[hnunez4399]

Is this a built in access function?

 

[willir]

These functions are part of the VBA used by Access. Use Help within Access to learn more.