Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting a field to compose itself of two other feilds

Status
Not open for further replies.

Strailnet

Technical User
Aug 23, 2002
2
CA
This is the deal,

I want a feild to compose itself of two other feilds. I want to have this feild look at two toher feilds to get its Data. These other feilds are "Surname" and "GivenName". The feild I want to compose out of these two feilds, I want to display in this manner, surname_givenname.jpg - in this new feild. So I want the "_" & ".jpg" to be constants in the feild, and have the surname and givenname data from that record make up the rest of that feild. Make sense? If so I could use some help, I'm lost.
 
I believe in the control source you can simply set that equal to:

=[Surname] & "_" & [GivenName] & ".jpg"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top