G
Guest
Hi Everyone!
I have a table that I've created and I'm trying to do an append query to an
existing table...all my fields match the existing table. One of my fields
"ItemNo" looks like this... CRIA3DA000
My question is...
Can someone show me how to write the code to generate the middle 4
characters for this "ItemNo" field so I don't have to manually enter this for
13000+ records.
*the CRI is always the first 3 characters
*the 000 is always the last 3 characters...
so I only need the middle 4 characters to output randomly which can include
NUMERIC and ALPHA but NO symbols, punctuations, etc and NO DUPLICATES.
Any help would be appreciated. Also could you keep in mind that I'm a
NEWBIE when writing code.
Thanks - Crystal
I have a table that I've created and I'm trying to do an append query to an
existing table...all my fields match the existing table. One of my fields
"ItemNo" looks like this... CRIA3DA000
My question is...
Can someone show me how to write the code to generate the middle 4
characters for this "ItemNo" field so I don't have to manually enter this for
13000+ records.
*the CRI is always the first 3 characters
*the 000 is always the last 3 characters...
so I only need the middle 4 characters to output randomly which can include
NUMERIC and ALPHA but NO symbols, punctuations, etc and NO DUPLICATES.
Any help would be appreciated. Also could you keep in mind that I'm a
NEWBIE when writing code.
Thanks - Crystal