Hi All
I have a database with a table that I never want to have decimals in certain currency fields, if there is a decimal it needs to be rounded to a whole number.
Using the design view > decimals property doesnt actually change the data, just how its displayed, which doesnt fix things later on where SQL code etc will still end up displaying the decimal.
So my question is, how can I hard code certain fields to ONLY be whole number, in real data not just display format.
Cheers