AccessDabbler
New member
- Local time
- Yesterday, 17:53
- Joined
- Jun 24, 2014
- Messages
- 7
Hello, I've been trying to figure this out and am probably overthinking it :banghead:
my database has a text field that says "Period"
I have a date field called "Entry" and a date field called "Exit"
I want to write something that will populate the field "Period" with words to describe the dates in "Entry" and "Exit"
For instance if the Entry and Exit dates are between 1/1/1940 and 12/31/1949 I want it to populate the "Period" field with "Forties"
but it would also go on to 1/1/1950 and 12/31/1959 and populate "Period" with "Fifties" etc
Does this make sense to anyone? Can it be done?
Thanks!
my database has a text field that says "Period"
I have a date field called "Entry" and a date field called "Exit"
I want to write something that will populate the field "Period" with words to describe the dates in "Entry" and "Exit"
For instance if the Entry and Exit dates are between 1/1/1940 and 12/31/1949 I want it to populate the "Period" field with "Forties"
but it would also go on to 1/1/1950 and 12/31/1959 and populate "Period" with "Fifties" etc
Does this make sense to anyone? Can it be done?
Thanks!