Exporting data

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 said:
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?
Click to expand...


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
 
Back
Top