Hi All,
This is my first post in this forum. I've done pretty good working with Access for the past 20 years. Mainly because I didn't get really deep into the program and what it can do. I stuck to basic tables, forms, queries and such.
My issue now is, I have a Work Order database that i created. Most fields I'll either enter by hand or from a combo box on a form and they write to the Work Order table like they should. One of the fields is the Work Order Number and I decided to upgrade this field so it would self-populate. I added a Current Date field that pulls the last two digits of the year for me, I added a field that calculates the Julian Date for me, and I have an Autonumber field that creates the Task Number.
In a query I created a new field that concatenates the two digit year, the Julian Date, and the Task Number. The problem I have is, I can't get that number to write to the main Work Order Table. Can I create a field in the Work Order table that would do the concatenation instead of doing it in a query? If so, how?
Any assistance would be greatly appreciated.
This is my first post in this forum. I've done pretty good working with Access for the past 20 years. Mainly because I didn't get really deep into the program and what it can do. I stuck to basic tables, forms, queries and such.
My issue now is, I have a Work Order database that i created. Most fields I'll either enter by hand or from a combo box on a form and they write to the Work Order table like they should. One of the fields is the Work Order Number and I decided to upgrade this field so it would self-populate. I added a Current Date field that pulls the last two digits of the year for me, I added a field that calculates the Julian Date for me, and I have an Autonumber field that creates the Task Number.
In a query I created a new field that concatenates the two digit year, the Julian Date, and the Task Number. The problem I have is, I can't get that number to write to the main Work Order Table. Can I create a field in the Work Order table that would do the concatenation instead of doing it in a query? If so, how?
Any assistance would be greatly appreciated.