Changing Numbers to Text in a query

[MacNut2004]

Hello,

I have a number in a query that i need to change to text because my data,
i.e. 555767 is being returned as 555,767 and i do not want it to contain a
comma. Any ideas?

Thank you!
MN

 

[Jeff Boyce]

Perhaps you only need to change the "display" of the number, not the data
type...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MacNut2004]

Well, I need to export the results of this query to excel so it needs to be
changed to text...any ideas?

 

[Jeff Boyce]

Try the CStr() function in your query.

(but if you tell Excel that "100,000" is "text", you won't be able to do
math on it!)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[MacNut2004]

no worries....i don't want to do math on that. ahh, it didn't work! is there
a command in VBA that can change the number to text?

thank you!!!

 

[Jeff Boyce]

The following works for me:

* create a query
* add a field with a number data type
* create a new field, something like: NewField: CStr([YourField])

This creates a text (string) of whatever was in [YourField]

Works for me...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John W. Vinson]

no worries....i don't want to do math on that. ahh, it didn't work! is there
a command in VBA that can change the number to text?

Yes:

strNumber = Format([numberfield], #)

John W. Vinson [MVP]

 

[KARL DEWEY]

If you still have trouble then try this ---
NewField: "'" & CStr([YourField])
This concatenates a single quote in front and Excel treats it as a text and
does not display the single quote.
--
KARL DEWEY
Build a little - Test a little

The following works for me:

* create a query
* add a field with a number data type
* create a new field, something like: NewField: CStr([YourField])

This creates a text (string) of whatever was in [YourField]

Works for me...

Regards

Jeff Boyce
Microsoft Office/Access MVP

no worries....i don't want to do math on that. ahh, it didn't work! is
there
a command in VBA that can change the number to text?

thank you!!!

 

[MacNut2004]

Jeff & Karl,

Neither way is working! It's still coming up with a comma! Anyway in VBA
to do this? I am coming up with this value using vba code and the split
function.

If you still have trouble then try this ---
NewField: "'" & CStr([YourField])
This concatenates a single quote in front and Excel treats it as a text and
does not display the single quote.
--
KARL DEWEY
Build a little - Test a little

The following works for me:

* create a query
* add a field with a number data type
* create a new field, something like: NewField: CStr([YourField])

This creates a text (string) of whatever was in [YourField]

Works for me...

Regards

Jeff Boyce
Microsoft Office/Access MVP

no worries....i don't want to do math on that. ahh, it didn't work! is
there
a command in VBA that can change the number to text?

thank you!!!

:

Try the CStr() function in your query.

(but if you tell Excel that "100,000" is "text", you won't be able to do
math on it!)

Regards

Jeff Boyce
Microsoft Office/Access MVP

Well, I need to export the results of this query to excel so it needs
to
be
changed to text...any ideas?

:

Perhaps you only need to change the "display" of the number, not the
data
type...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Hello,

I have a number in a query that i need to change to text because my
data,
i.e. 555767 is being returned as 555,767 and i do not want it to
contain a
comma. Any ideas?

Thank you!
MN

 

[Jeff Boyce]

Have you tried John V's approach?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff & Karl,

Neither way is working! It's still coming up with a comma! Anyway in VBA
to do this? I am coming up with this value using vba code and the split
function.

If you still have trouble then try this ---
NewField: "'" & CStr([YourField])
This concatenates a single quote in front and Excel treats it as a text
and
does not display the single quote.
--
KARL DEWEY
Build a little - Test a little

The following works for me:

* create a query
* add a field with a number data type
* create a new field, something like: NewField: CStr([YourField])

This creates a text (string) of whatever was in [YourField]

Works for me...

Regards

Jeff Boyce
Microsoft Office/Access MVP

no worries....i don't want to do math on that. ahh, it didn't work!
is
there
a command in VBA that can change the number to text?

thank you!!!

:

Try the CStr() function in your query.

(but if you tell Excel that "100,000" is "text", you won't be able
to do
math on it!)

Regards

Jeff Boyce
Microsoft Office/Access MVP

Well, I need to export the results of this query to excel so it
needs
to
be
changed to text...any ideas?

:

Perhaps you only need to change the "display" of the number, not
the
data
type...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

message
Hello,

I have a number in a query that i need to change to text
because my
data,
i.e. 555767 is being returned as 555,767 and i do not want it
to
contain a
comma. Any ideas?

Thank you!
MN

 

[MacNut2004]

What is John V's approach? I tried both your approach and Karl's.

Thx,
MN

Have you tried John V's approach?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff & Karl,

Neither way is working! It's still coming up with a comma! Anyway in VBA
to do this? I am coming up with this value using vba code and the split
function.

If you still have trouble then try this ---
NewField: "'" & CStr([YourField])
This concatenates a single quote in front and Excel treats it as a text
and
does not display the single quote.
--
KARL DEWEY
Build a little - Test a little


:

The following works for me:

* create a query
* add a field with a number data type
* create a new field, something like: NewField: CStr([YourField])

This creates a text (string) of whatever was in [YourField]

Works for me...

Regards

Jeff Boyce
Microsoft Office/Access MVP

no worries....i don't want to do math on that. ahh, it didn't work!
is
there
a command in VBA that can change the number to text?

thank you!!!

:

Try the CStr() function in your query.

(but if you tell Excel that "100,000" is "text", you won't be able
to do
math on it!)

Regards

Jeff Boyce
Microsoft Office/Access MVP

Well, I need to export the results of this query to excel so it
needs
to
be
changed to text...any ideas?

:

Perhaps you only need to change the "display" of the number, not
the
data
type...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

message
Hello,

I have a number in a query that i need to change to text
because my
data,
i.e. 555767 is being returned as 555,767 and i do not want it
to
contain a
comma. Any ideas?

Thank you!
MN

 

[Jeff Boyce]

In my view of this thread, John W. Vinson responded to your post at 11:11 am
today.

Regards

Jeff Boyce
Microsoft Office/Access MVP

What is John V's approach? I tried both your approach and Karl's.

Thx,
MN

Have you tried John V's approach?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff & Karl,

Neither way is working! It's still coming up with a comma! Anyway in
VBA
to do this? I am coming up with this value using vba code and the split
function.

:

If you still have trouble then try this ---
NewField: "'" & CStr([YourField])
This concatenates a single quote in front and Excel treats it as a
text
and
does not display the single quote.
--
KARL DEWEY
Build a little - Test a little


:

The following works for me:

* create a query
* add a field with a number data type
* create a new field, something like: NewField:
CStr([YourField])

This creates a text (string) of whatever was in [YourField]

Works for me...

Regards

Jeff Boyce
Microsoft Office/Access MVP

no worries....i don't want to do math on that. ahh, it didn't
work!
is
there
a command in VBA that can change the number to text?

thank you!!!

:

Try the CStr() function in your query.

(but if you tell Excel that "100,000" is "text", you won't be
able
to do
math on it!)

Regards

Jeff Boyce
Microsoft Office/Access MVP

message
Well, I need to export the results of this query to excel so it
needs
to
be
changed to text...any ideas?

:

Perhaps you only need to change the "display" of the number,
not
the
data
type...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

message
Hello,

I have a number in a query that i need to change to text
because my
data,
i.e. 555767 is being returned as 555,767 and i do not want
it
to
contain a
comma. Any ideas?

Thank you!
MN