Data changes in append query

[alecgreen]

Hi

I have a problem that I thought would be easy to resolve, but can't. I
am appending data from a query to a new table. The data in the
original query is a calculated field, producing a value say "1.58" but
when I run the append query to transfer tha data to the new table -
its shows "2" in the new table instead of the correct value of "1.58"

Any ideas please

Alec

 

[John W. Vinson]

Hi

I have a problem that I thought would be easy to resolve, but can't. I
am appending data from a query to a new table. The data in the
original query is a calculated field, producing a value say "1.58" but
when I run the append query to transfer tha data to the new table -
its shows "2" in the new table instead of the correct value of "1.58"

Any ideas please

Alec

Sounds like the datatype in the target table is the default Long Integer type
of Number. Integers are by definition whole numbers, and Access will round.

Change the datatype to something which will support decimals - a Currency
field if four decimals are appropriate, or a Number... Single Float, Number...
Double Float, or Number... Decimal datatype as appropriate for your needs.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com