Hello,
I have a table where I enter bid information - per square foot. Sometimes the difference between a winning bid and a losing bid is 2 cents. For example, a winning bid may be $17.02 per square foot and the losing bid is $17.04 per square foot.
When I enter this information into access (no matter what data type I select or how many decimal places) - Access lists them both as $17. I have no issues with this - but I know my client definitely will since they want to see things down to the penny.
I figure I shouldn't waste any more time trying to figure this out on my own and someone has probably went through it before and it's something simple........
Thx,
Lisa
I have a table where I enter bid information - per square foot. Sometimes the difference between a winning bid and a losing bid is 2 cents. For example, a winning bid may be $17.02 per square foot and the losing bid is $17.04 per square foot.
When I enter this information into access (no matter what data type I select or how many decimal places) - Access lists them both as $17. I have no issues with this - but I know my client definitely will since they want to see things down to the penny.
I figure I shouldn't waste any more time trying to figure this out on my own and someone has probably went through it before and it's something simple........
Thx,
Lisa