Help with query

A

alecgreen

Hi

I want to use a query to change a stock number field from 12345 to
"12345", but cant work out how to do this! Any ideas please

Alec
 
K

Ken Snell \(MVP\)

What is the data type of the stock number field right now -- Number? Text?

I assume that you want to make it a text string and not a number (that the "
characters are not meant to be part of the data value)?
 
A

alecgreen

What is the data type of the stock number field right now -- Number? Text?

I assume that you want to make it a text string and not a number (that the "
characters are not meant to be part of the data value)?

--

Ken Snell
<MS ACCESS MVP>








- Show quoted text
Click to expand...

I want to export the whole file to a CSV to then import to another
program, but the text type fields need to be enclosed in " ", hope
that makes it a bit clearer!

thanks

Alec
 
K

Ken Snell \(MVP\)

Is the field that contains 12345 a Number field type or a Text field type?
My suggestion for how to do what you seek depends upon your answer.
 
Top