[MS_AccessPros] Combinig values in multiple fields

 

Hello,

Ok so here it is. I have a table, and in this table i have three seperate fields which i need to combine into one field to create something akin to a serial number.
The fields are:
Technician, created Date and Document Number.
I need a number in the following format to be automatically generated after the document number is entered by the user.

WAR-R-TechnicianDate-Record Number
(WAR-R-JF05232011-01)

I have been trying to figure this out, but i am having ZERO luck.

Can anyone help?

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4
• New Files 2

Visit Your Group

MARKETPLACE

Find useful articles and helpful tips on living with Fibromyalgia. Visit the Fibromyalgia Zone today!

---

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___