Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rounding off figures...

Status
Not open for further replies.
BlairR

BlairR

Programmer
Oct 4, 2004
2
CA
Sorry for the newbie question, but I'm creating an expense database with Access 2000. When I type in 20.99 for example, it rounds it off to 21. How can I stop this?

Thanks, Pedro
 
Sort by date Sort by votes
Have you tried defining the field format in the table as 'CURRENCY' ??

Steady ...
 
Upvote 0 Downvote
Thanks! Changing to currency was it.

Blair
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

lameid
  • Locked
  • Question
Office / Access 365 Trusted locations and GP
Replies
0
Views
462
lameid
lameid
N2Life
  • Locked
  • Question
Graph too small in Office 365 Access
Replies
0
Views
294
N2Life
N2Life
arpeggione
  • Locked
  • Question
"Updates Available" banner - disable Updates not working - Office 2016
Replies
1
Views
287
Darrylles
Darrylles
lameid
  • Locked
  • Question
Code Comparison in office - I'd normally use Notepad++ with compare plugin - Not Word Doc compare? 1
Replies
2
Views
212
lameid
lameid
sparkbyte
  • Locked
  • Question
Access Front end that can work offline??
Replies
7
Views
368
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top