Losing data

P

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.
 
A

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
 
G

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.
 
J

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.
Click to expand...

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