1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Sequential numbering help

Discussion in 'MS Access' started by gear, Apr 9, 2007.

  1. gear

    gear New Member

    My database has a date field, year field and numberfield. The number field is set with DMax which will reset to No.1 when the year changes. I want help on the following:

    For current year's records - The DB should use the current year's records only for actual working i.e. data entry, edit, search, print etc.

    For previous year's records - The DB should allow only search and print and NOT for data entry and edit.

    How can I achieve this. Please help.

Share This Page