Adding to create the ID

[Jacobm001]

I've decided it's time to really start learning Access so my first major attempt is a database to keep personal records of my grades and such at college. My biggest problem though seems to be a simple one.



For my Unique ID on a particulare table I want it to be a combination of two boxes. I have my table set up with the following fields:

• Unique ID
• Department
• Course #
• Credits
• Earned Grade

I'd like the Unique ID to be combination of the department + course #. I keep them separated as such for easier sorting and manipulation later, but obviously neither alone makes a good ID by themselves.

[maximus]

welcome to the forum!!!!!!!!!

To combine the two fields:
=[DepartmentID]&[Course#]

Now its upto u how and when you want this code to run.