Megacitizen
Registered User.
- Local time
- , 19:34
- Joined
- Mar 22, 2012
- Messages
- 130
I'm working on a DB recording the stats of various teams from around the world, all working in the same city at various stages throughout one calender year. The year is split into 4 quarters which we are actually terming as "Waves", numbered 1-4.
I am trying to set up a calculation whereby the user inputs the date a team arrives in the city, and the form then calculates whether they are Wave 1, 2, 3 or 4.
I have got the validation for the Wave field as >0 and <5 but not sure if I need a code or an expression for the calculation. Also, I can easily calculate records for THIS year (specific dates where a team arriving on or after that date is in a specific wave), but I need to consider future years as the actual dates when a wave changes will vary from year to year. We do a new city every 2 years.
Using MS Access 2010
I am trying to set up a calculation whereby the user inputs the date a team arrives in the city, and the form then calculates whether they are Wave 1, 2, 3 or 4.
I have got the validation for the Wave field as >0 and <5 but not sure if I need a code or an expression for the calculation. Also, I can easily calculate records for THIS year (specific dates where a team arriving on or after that date is in a specific wave), but I need to consider future years as the actual dates when a wave changes will vary from year to year. We do a new city every 2 years.
Using MS Access 2010
Last edited: