Export troubleshooting

[Musa via AccessMonster.com]

Hello,

I am trying to Export a Text Field with the following values 1 , 2 , or 3.
The Field is a combo box on the form and the USER selects from the drop down.
The Value is stored appropriately, however, when I attempt to EXPORT, this
field becomes 1 and 0's only. I should also mention that this field is part
of the primary key. The other Primary key for this table is an ID - stored
as a number. Could this be the problem?

Thanks

 

[Jack Leach]

I'm not sure why the export isn't going right (0 and 1 seems like it might be
an issue related to Boolean typecasting, except Booleans are 0 and -1).

On another note... is your primary key a multi-field key (set in table
design with two "keys") or are you storing the value of the text field in
both the text field and in as part of a primary key? If you have a single
primary key field that is a number plus some other "code" that you store in
the field... that's not a good idea at all. That's a case of storing the
data twice, which is never a good thing.

Also, just out of curiousity, why are you using a text field to store a
value of 1, 2 or 3? Text fields are far far larger than number fields... why
not store it as a Byte or Integer?

What method(s)/Format(s) are you using to export? Have you tried exporting
to different data formats to see if you get the same results? Etc., etc..

--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)

 

[Musa via AccessMonster.com]

Jack,

I have the following set up :

Table_1

Clt_ID Number Long Integer - PK ( unique number given for each
individual)
timept Number Long Integer - PK ( time point for each individual
1= pre , 2=post )

I am using Export to Excel. I have a co-worker that is using MS Office 2007
and I have 2003.
I tried importing / exporting to Excel... copying and pasting (using special
text).. I get the same results.. I'm puzzled..

I'm not sure why the export isn't going right (0 and 1 seems like it might be
an issue related to Boolean typecasting, except Booleans are 0 and -1).

On another note... is your primary key a multi-field key (set in table
design with two "keys") or are you storing the value of the text field in
both the text field and in as part of a primary key? If you have a single
primary key field that is a number plus some other "code" that you store in
the field... that's not a good idea at all. That's a case of storing the
data twice, which is never a good thing.

Also, just out of curiousity, why are you using a text field to store a
value of 1, 2 or 3? Text fields are far far larger than number fields... why
not store it as a Byte or Integer?

What method(s)/Format(s) are you using to export? Have you tried exporting
to different data formats to see if you get the same results? Etc., etc..

Hello,

[quoted text clipped - 6 lines]

Thanks

 

[Ken Snell]

Show us how you're trying to do the export, and to what type of data file.
Your result sounds as if you're exporting the result of a boolean comparison
expression. Are you exporting a table? or a query?