Help with query

  • Thread starter Thread starter alecgreen
  • Start date Start date
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
 
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)?
 
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
 
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.
 
Back
Top