If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Resetting" value back to zero for new year
Hi, beginner here.
I have a form that automatically enters the next ID number for new entries. The problem is, I want this ID number to return back to 0 at the beginning of each year. For example, 2004 had 64 entries. For 2005, the next ID keeps coming up as 65 (of course) but I want it to be zero. Below is the expression in the form for the ID number. Any advice is greatly appreciated....keeping in mind this database was created a year ago and can't be totally revamped. THANKS! =DMax("[ID]","tblDrawing Index")+1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"Back" button from custom shows causing problems | Gary A. | Powerpoint | 1 | December 1st, 2004 03:47 PM |
Add a FIXED MONTH and DAY with the CURRENT YEAR | texcel | General Discussion | 1 | June 23rd, 2004 01:36 AM |
Back Cross Reference | Sukhjeet | General Discussion | 1 | May 29th, 2004 04:57 PM |
Combining two queries or two different table on a same report . | sha | Setting Up & Running Reports | 7 | May 28th, 2004 10:41 AM |
Revert Back to Menu | Dave Y | Powerpoint | 3 | May 26th, 2004 02:21 PM |