Exporting excel file from query

[Elmobram22]

Hi,

Am trying to export an excel (97-03) file from a query I have. Some of the columns have exported as number values (as its linked via unique id's). I want it to export certain columns as the text columns. I have tried the lookup route but it doesn't seem to make a difference. Any ideas?

Cheers,

Paul

 

[pr2-eugin]

You need to perform the JOIN between the table and its lookup table to get the Column that has text.. This is one reason why you should avoid using Lookup fields in tables.

 

[Geotch]

Convert the number to a string using the str function. IDasString: Str([ID]) - id was my number field and I chose to call it IDasString.

I've added a picture to show you that it works.

 

[Elmobram22]

Pr2-Eugine:

Do you mean only set up number columns in tables and build the relationships manually?

 

[pr2-eugin]

Relationships should have already been defined ! When you bring the tables in Queries that JOIN will be established for you.