why is my data getting rounded???

[kskinne]

i have a field in my database table that is formatted as currency, to 2 decimal places. when i enter data in the table however, it displays the number to two decimals but rounds it to the nearest whole dollar amount. for example, if i enter 15.99 it changes it to 16.00. any idea why it is doing this, and how can i avoid it?

thanks,
kevin

 

[kskinne]

had the data type initially set to number, using the currency format. i changed the data type to currency, and it now works fine (?)

kevin

 

[SydneyGeek]

Yeah, Access is picky about data types. I just tried out a few variants to illustrate. Note: Decimals were left Auto in the field settings.

Book1
	A	B	C	D	E
1	DataType	FieldSize	Format	Enter	Display
2	Number	LongInteger	[blank]	15.99	16
3	Number	Decimal	Currency	15.99	16.00
4	Number	LongInteger	Currency	15.99	15.00
5	Number	LongInteger	Fixed	15.99	16.00
6	Currency	N/A	Currency	15.99	15.99
Sheet1

The Currency data type is a scaled decimal, the others are binary. Bottom line, if you have currency values, use the Currency data type.

Denis

 

[kskinne]

thank you for the info - could you by chance recommend a good book that will help me with database design in access? i am fairly proficient in Excel and VBA, but feel like a fish out of water in Access - it's not that I'm not familiar with database design, and in fact I can write most of my own queries in SQL, but I am just not very familiar with the ins and outs of the Access program. was hoping you might know of a good reference that will help me in that dept.

thanks,
kevin

 

[SydneyGeek]

I recently bought Access 2002 Inside Out by Helen Feddema. It's the best general Access text that I've come across so far. The Developer's Handbooks by Litwin, Getz and Gilbert are also good from the coding point of view but they won't give you much detail on database design as such. Another general DB book (great on the principles, without specifically covering any database product) is Database Design for Mere Mortals, by Mike Hernandez.
Note: This is my personal view. Others may have different feedback

Hope this helps

Denis