Access File System

Hey Guys, I'm trying to set up a data base for an office file system. We have alot of paper stuff here and we're trying to use access to help us file everything in an easier way. I'm trying to set it up so that Access will give me a file number, and a sub number. So far I've set up the numbers for the main categories, but I'm trying to come up with a formula that will take the main ID cell and add 1 for the first file number cell and add 2 for the second cell and 3 for the third cell and so on. Can anyone hlep?

"=?Utf-8?B?Z3BlcnNvbg==?=" wrote in
:

So far I've set up the numbers for the main categories, but I'm trying
to come up with a formula that will take the main ID cell and add 1
for the first file number cell and add 2 for the second cell and 3 for
the third cell and so on. Can anyone hlep?


this works for a single-user system:

Nz(DMax("SerialNumber", "Files", "MainID=" & dwMainIDNumber), 0) +1



Going from the middle:

"MainID=" & dwMainIDNumber

creates a WHERE clause to look for serialnumbers associated with the MainID
you are currently looking for.

DMax("SerialNumber", "Files", "MainId=11023")

looks up the highest serialnumber allocated so far, kept in the Files
table.

Nz(etc, 0)

checks the returning number for NULL (for example, if it's a new MainID
with no files yet allocated) and replaces it with zero.


Nz() + 1

adds one to get the next number -- or 1 if it's the first one.

Hope that helps


Tim F