I Inetta Registered User. Local time Today, 15:16 Joined May 26, 2012 Messages 21 May 26, 2012 #1 What type of a formula or criteria do I need in my query to enter a starting number of 1 in my table and then every year on a specified date - have that number to go to 2.
What type of a formula or criteria do I need in my query to enter a starting number of 1 in my table and then every year on a specified date - have that number to go to 2.
gemma-the-husky Super Moderator Staff member Local time Today, 20:16 Joined Sep 12, 2006 Messages 16,072 May 27, 2012 #2 and year 10/11, the starting number will be???? zero gives a problem if you are using numbers the next year, 1 gives a duplication problem
and year 10/11, the starting number will be???? zero gives a problem if you are using numbers the next year, 1 gives a duplication problem