Exporting data

[Guest]

I am trying to export a query from access into excel but the as part of the
export the number values are exported rather than the word chosen.

For example - the title field is a pull down menu in the database where 1 =
Mr and 2 = Miss the export is transferring 1 rather than Mr and 2 rather than
Miss.

Is there a way round this?

 

[Jason W. Martin]

Be sure to check the box "Save formatted" when exporting.

-Jason

 

[rwr]

I am trying to export a query from access into excel but the as part of the
export the number values are exported rather than the word chosen.

For example - the title field is a pull down menu in the database where 1 =
Mr and 2 = Miss the export is transferring 1 rather than Mr and 2 rather than
Miss.

Is there a way round this?

If Mr. and Miss come from a table
1. include that table in the query you use to export.
2. create a relationship or join from your table to the new table on the
numeric field.
3. Include the Mr. Miss field in your query.
4. Remove the numeric field from your query.

If Mr. Miss comes from a value list then
Title: iif(NumberField=1, "Mr.", iif(NumberField=2, "Miss", " "))

You need to repeat the iif for every value you have.

This is nesting the iif statement in each true path of the previous iif
statement. when you get to the last iif statement, put something like a
blank, " " or "N/A", in the false path of the last iif statement. make
sure you include the correct ( ) for all of the iif statements you use.

Air code

Ron