Functions

[Garry]

Hi

I need to export a query to a text file that contains both alpha and numeric
fields

How can I force the numeric fields to text as to get "123","ABC"

thanks, Garry

 

[Allen Browne]

In query design view, instead of a field such as Amount, type an expresion
like this into the Field row:
Trim(Str([Amount]))

Access should recognise this as a Text type field, and so add the quotes
when you export it.

 

[Garry]

Just the job

Thankyou

In query design view, instead of a field such as Amount, type an expresion
like this into the Field row:
Trim(Str([Amount]))

Access should recognise this as a Text type field, and so add the quotes
when you export it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi

I need to export a query to a text file that contains both alpha and
numeric fields

How can I force the numeric fields to text as to get "123","ABC"

thanks, Garry