Combining an Autonumber Field with a Text Field

[labprof]

Can anyone help me with this challenge.
I have two fields in a table called Document_tbl. that I want to combine and have the results display in another text field.
The two fields are Rev(which is a text field) and
DocIndex(which is an autonumber field) I want a third field to display the results of the two combined fields in a text box or field.

Example Rev= B and DocIndex= 1. I would like the third field Training Req to equal B1

Could someone tell me if this can be done?

Thanks
Labprof

 

[IGPCS]

type this in the text box record source

text1 = [Rev]& [DocIndex]

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[IGPCS]

sorry in the textbox control source

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[TheAceMan1]

. . . and with a little clean-up:

[blue]text1 = [Rev]& [DocIndex]
   should be:
text1 = [Rev][COLOR=black red] [/color]& [DocIndex][/blue]

See Ya! . . . . . .

 

[IGPCS]

TheAceMan How ya doin?

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[TheAceMan1]

IGPCS . . .

Always Good!

I'm sure you are too!

See Ya! . . . . . .