Losing data

  • Thread starter Thread starter plewiston
  • Start date Start date
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.
 
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
 
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.
 
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.
 
Back
Top