You are here:

Using MS Access/MS Access - How to create a sequence number field form many fields

Advertisement


Question
Hi,
i would like to know if it is possible in access to create a field (named sequence)from other fields from the same table:
i have table named "Document" with many fields
1-Project number ex 020842
2-Package Number ex C2001
3-Sequence Number which is the sequence of a combination created by the 2 other fields ex 020842-C2001-0001, if one one them changed, i should receive a new sequence number
thanks

Answer
Sure... just use a CALCULATED QUERY FIELD with some STRING CONCATENATION.


Be sure to visit my web site and watch my FREE 90-minute Microsoft Excel Video Tutorial

Cordially,
Richard Rost
599CD Computer Training

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Richard Rost

Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site, and free Access 101 tutorial.

Experience

I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

©2016 About.com. All rights reserved.