When Exporting it changes the Values

S

Sharon Walls

Hello,
I have a series of fields that query to a another table to create a look-up
field. I am storing the number in the table. When I go to export, it comes in
a number off of what the original is.
For example, if it is stored as 4 in my table, it exports as three in excel.
does anyone know why this is happening and how I can fix it?

Thank you in advance!

Sharon Walls
 
J

John W. Vinson/MVP

Hello,
I have a series of fields that query to a another table to create a look-up
field. I am storing the number in the table. When I go to export, it comes in
a number off of what the original is.
For example, if it is stored as 4 in my table, it exports as three in excel.
does anyone know why this is happening and how I can fix it?

Thank you in advance!

Sharon Walls
Click to expand...

You're probably another victim of the misleading, misdesigned so
called "Lookup Field" type.

Typically you would have a Lookup Table containing a numeric ID and a
(usually) text value to be looked up; in your case, it seems you're
looking up a numeric value.

The Lookup field makes it APPEAR that your table contains the
looked-up value. It doesn't. It contains the meaningless ID number,
which is just a *link* to the lookup. That simple fact is concealed
from your view by the abominable Lookup Wizard.

The solution is to create a Query joining your table to the lookup
table (joining on the ID field). Select whatever fields you want to
see from your table, and the looked-up value from the lookup table.
Export *that query* rather than exporting the table.
 
Y

yy

John W. Vinson/MVP said:
You're probably another victim of the misleading, misdesigned so
called "Lookup Field" type.

Typically you would have a Lookup Table containing a numeric ID and a
(usually) text value to be looked up; in your case, it seems you're
looking up a numeric value.

The Lookup field makes it APPEAR that your table contains the
looked-up value. It doesn't. It contains the meaningless ID number,
which is just a *link* to the lookup. That simple fact is concealed
from your view by the abominable Lookup Wizard.

The solution is to create a Query joining your table to the lookup
table (joining on the ID field). Select whatever fields you want to
see from your table, and the looked-up value from the lookup table.
Export *that query* rather than exporting the table.
Click to expand...
 
Top