Recent content by malcolmedward

First time using calculated fields in a table because first time using Access 2010 but if there are still problems then I will revert to using a query. If I use the suggested format casting the result to an integer, then is the result simply displaying the whole number 5 but will still use...

Is there anyway to turn off the rounding function in calculated fields - I need to divide a currency amount by a whole number to calculate the number of full coin bags that will be needed (bags contain different totals according to the coin value) - a whole number. Then the result is used to...

Hi from Malcolm