Functions

  • Thread starter Thread starter Garry
  • Start date Start date
G

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
 
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.
 
Just the job

Thankyou


Allen Browne said:
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.

Garry said:
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
Click to expand...
Click to expand...
 
Back
Top