zero number not a zero

[ijswalker]

HI,

I have a table in my access database that has zero values. When I query the table I get zero values in my query but they are not really zeros. I have the column in the base table formatted to Double. They seem to have many decimal places after then when I click in the column. So, if I want to use the column to calculate with another column then I am not getting the right answer.

Can anyone help.

 

[pbaldy]

Probably a floating point issue. Try changing the data type of that field to Currency.

 

[ijswalker]

Still getting the same. I've even tried rounding the field before I imported it into Access from excel

 

[pbaldy]

Can you post a sample db? You should not see that behavior with a Currency data type, only Double and Single (if it's what I think it is). Not format, but the actual data type of the field.

 

[ijswalker]

I think you are correct with the floating decimal point. If the original text file is set to space delimited then I keep having this problem. If the file is set to tab delimited then I am able to import the file and have the formats work the way I want them to. In short - it looks like I need to go to the source file and deal with the issue there.

Thanks for your help.