Creating a field from other fields

[Carmen]

I hope someone can give me some assistance as I am new to programming. I have a table in Access with the following fields: ModuleID, SectionID, SessionDate, Semester. What I'm trying to do is combine the Year in SessionDate, Semester, and ModuleID to automatically create SectionID. For example, if ModuleID = 3, SessionDate = 12/01/01, and Semester = Fall, then the SectionID would = 01Fall3. Therefore, the SectionID will change with every record depending on the values of the other three fields in that record. Is there any way to automate this with VBA? Thanks for any help!

 

[Avaughan]

The absolute easiest way to do this is to join the fields in a query with the & symbol
SectionId:[SessionDate]&[ModuleId]&[Semester]

The next way would be to create your new field in your form as an unbound object using the expresion builder. It would use the same function as above

 

[Carmen]

Thank you Avaughan! That worked great!