I'm not a programmer and I'm fairly new to MS Access. I've started a database to track part numbers. A sample part number is 16352 or 1423.
I created a query to calculate the number of part numbers for each specific part number. For instance, in my query "Number of Parts," I have 2 columns. The first column lists the different part numbers and the second column counts the number of times the part number has been entered. So it looks like this ..
1423 = 4
1578 = 6
16352 = 2
etc
Now, I'd like to take it one step further. Instead of identifying each part by an AutoNumber, I'd like my form to automatically enter the count number followed by the part number. So if I enter 16352 in my form in the part number field, I want my form to automatically enter 3-16352 for the identity number.
Any ideas on how I can achieve this? Thanks in advance for any help!
I created a query to calculate the number of part numbers for each specific part number. For instance, in my query "Number of Parts," I have 2 columns. The first column lists the different part numbers and the second column counts the number of times the part number has been entered. So it looks like this ..
1423 = 4
1578 = 6
16352 = 2
etc
Now, I'd like to take it one step further. Instead of identifying each part by an AutoNumber, I'd like my form to automatically enter the count number followed by the part number. So if I enter 16352 in my form in the part number field, I want my form to automatically enter 3-16352 for the identity number.
Any ideas on how I can achieve this? Thanks in advance for any help!
