Decimals rounding even with 'Double' Field Size

[jay_x]

Hi Everyone,

For some reason I cannot enter decimal values without the number rounding up or down. I've already set it to 'Number' and 'double' and have also tried 'Fixed' set to 2 decimal places. Right now the only way it works is if I set it to 'Text'. However I need to do some calculations with these values eventually.

What's strange is I have another table in the same database that is NOT rounding and is working just fine. Any ideas?

thanks,
j-

 

[boblarson]

Have you changed the FIELD data type in the table from Long Integer which is the default? Changing it on the form isn't going to change what's in the table.

 

[jay_x]

Thanks.. yeah, changed it in the Table properties not just the form.

I think it's a relationship issues since it's going to from one to many. Looks like my only option is to create another table and relate it to the previous table. If someone can think of a simpler solution, I'd greatly appreciate it.

j-

 

[boblarson]

I think it's a relationship issues since it's going to from one to many.

Not likely, but what is the data that is being stored in this field? And why is it linked to another field. If it is an ID then it SHOULD be Long Integer and NOT Double. You shouldn't link on Doubles because of rounding errors they may not link properly.