Auto Number

W

weedavie22

Is it possible to create a reference based on another reference.
Heres an example.

My records are stored under CLIENTCODES similar to these:
0001GLA
0002GLA
0003GLA
0004GLA....
Now the problem, there can be duplicate CLIENTCODES so now what I wan
to do is have a field in my form that counts how many duplicat
clientcodes of the current record there are and assign a reference s
if I had three 0001GLAs and two 0002GLAs the ref would be:
0001GLA/1 0002GLA/1
0001GLA/2 0002GLA/2
0001GLA/3

Hense if I were to input a 4th 0001GLA it will be 0001GLA/4

Hope this makes sense

Any help would be really appreciated as this is driving me up the wall

weedavie2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto re-numbering of FIGURES in Word 1
multiple duplication of records 0
Extracting data from Multiple columns to a Single row 3
Require help on slight twist to auto-incrementing a number 7
Count Records for this week, this month, this quarter, this year 5
How do you add auto number system to existing form in access? 3
Checking for duplicates 3
Access Subforms - Master/Child fields - one-to-many relationship 1

Top