Losing data

[plewiston]

When I append one table to another through a query I am
losing data in some of my fields. I'd like to know why
this is happening and how it can be prevented in the
future. Any suggestions? Thanks in advance.

 

[Andy]

If some of Your controls are memos they may be trunacated of 255 characters.

It happened to me. Doug was kind enough to help with the answer.

If it is only the memos not containing all text write back and I'll post the
answer. It will need some modification to match Your needs.

Andy

 

[Guest]

The data I am losing is numeric. The format of the field
is set at number/double. I am searching for some kind of
pattern of numbers being dropped.

 

[John Vinson]

When I append one table to another through a query I am
losing data in some of my fields. I'd like to know why
this is happening and how it can be prevented in the
future. Any suggestions? Thanks in advance.

Please post the SQL view of the query and some indication of the
datatypes of the relevant fields in both tables.