G
Guest
Hello,
We need to put into an Access database all the records of assents that we
have been recording by hand writing in books, one book per year. The way to
identify each record is by the combination of three fields: Year of the book,
page number, and line number. Now, we are not going to use that as a key
anymore, however we need to type in this information since it is already like
that in our books.
Year of book: 2006 (this is going to be a default number and we are going
to change it, obviously, once a year)
Page number: _ _ _ (We need it to numbering each new record from 1 to 300,
and then when the year number change we need the page number to star over
from 1)
Line number: _ _ (We need it to numbering each new record record from 1 to
45, and when the page number change we need that the line number star over
from 1)
How could I do it ? Is there any way to do it or do we need to type in
manually and be careful of not skipping numbers?
Cheers,
Iovana
We need to put into an Access database all the records of assents that we
have been recording by hand writing in books, one book per year. The way to
identify each record is by the combination of three fields: Year of the book,
page number, and line number. Now, we are not going to use that as a key
anymore, however we need to type in this information since it is already like
that in our books.
Year of book: 2006 (this is going to be a default number and we are going
to change it, obviously, once a year)
Page number: _ _ _ (We need it to numbering each new record from 1 to 300,
and then when the year number change we need the page number to star over
from 1)
Line number: _ _ (We need it to numbering each new record record from 1 to
45, and when the page number change we need that the line number star over
from 1)
How could I do it ? Is there any way to do it or do we need to type in
manually and be careful of not skipping numbers?
Cheers,
Iovana