I need to add a text to a number field

[bowes884]

I'd like to take a branch number field, let's assume it is "223" and change it to "223 No Com". Is there a way to add the "No Com" on the end of it like that?

 

[ColinEssex]

Have the text in a separate field and concatonate it later in a query.

Col

 

[NoFrills]

Off hand, I have to say No. If you have it set up as a Number field, then numbers are all you are allowed to enter. I could be wrong, just given my opinion as I do not know of a way to do that. I am sure that are work arounds for it.

Do you use this field for any calculations? I often use text fields in replace of number fields because I know the field is there for visual reasons and no calculations are needed on it. Does this field have to be a number field ?

 

[bowes884]

What if its a text field, how would I add the "No Com" on the end of all teh 223s?

 

[ColinEssex]

Update query

Col

 

[ScottGem]

I'd like to take a branch number field, let's assume it is "223" and change it to "223 No Com". Is there a way to add the "No Com" on the end of it like that?

The real issue here is whether branch number an the text you want to add are already part of your record. If they are they you do NOT want to store the value in a separate field. You can concatenate them for display whenever you need to with the expression:

=[BranchNum] & [textfield]

If the text is a constant that will never vary then use:

=[BranchNum] & " No Com"