Hello All,
I have a table in Access 97 that is used to record the issue of books of tickets that are serial numbered with 50 tickets per book. When I ussue a new book of tickets to someone, I enter the first serial number in field firstnum, I then enter the number from the last ticket in field lastnum. What I would like is to enter first number only, and get lastnum to enter automatically. I guess it can be done on a form, but wondered if it is possible in the table.
TIA.
Dave
I have a table in Access 97 that is used to record the issue of books of tickets that are serial numbered with 50 tickets per book. When I ussue a new book of tickets to someone, I enter the first serial number in field firstnum, I then enter the number from the last ticket in field lastnum. What I would like is to enter first number only, and get lastnum to enter automatically. I guess it can be done on a form, but wondered if it is possible in the table.
TIA.
Dave