Losing data

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

"plewiston" wrote in message
...
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.

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.

-----Original Message-----
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

"plewiston" wrote
in message
...
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.


.

On Mon, 12 Jul 2004 10:38:27 -0700, "plewiston"
wrote:

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.


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public