Round up issue?

[Hammer]

I have a table created in access 2007 & I seem to have an odd problem which I'm hoping somebody can cure for me.



If I enter 1.50 into a field for instance it is automatically rounded up to show 2.00, how do I get it to show 1.50 in the table.

In the properties tab the field is formatted as
Data Type - Number
Format - Fixed
Field size - long Integrer
Decimal places - 2

Many Thanks

[NTC]

can't be defined as an Integer.

[Alex Motilal]

Field size should be Double
Alex

[Neopoetess]

Hello. I am a complete novice to Access 2007 and I'm learning as I'm going without a code dictionary of sorts. I am actually having a rounding down problem and want time under an hour to register as 1 hour. I'm using =DateDiff("h",[Time In],[Time Out]) in the Control Source and have the Field Size as Double. I have set the Default Value as 1 and tried using the ROUNDUP expression from Excel to no avail. I have my database complete except for this ONE glitch! As a side question, does anyone know if there are ActiveX Barcode controls for Access 2007 or is it just something new for 2010? Thanks in advance. Neo