legalhustler
Well-known Member
- Joined
- Jun 5, 2014
- Messages
- 1,171
- Office Version
- 365
- Platform
- Windows
I have a MS Access table where one column has dates i.e. 12/1/12, 7/15/14 and another column where I need the quarter for each date. The quarters are based on the following months:
Q1 = 10,11,12
Q2 = 1,2,3
Q3 = 4,5,6
Q4 = 7,8,9
Is there a formula that I can put in the Validation Rule (under the Field Properties) or something to have this field be automatically determined? If not, will it only work in a query?? Is there a VBA for this?
Q1 = 10,11,12
Q2 = 1,2,3
Q3 = 4,5,6
Q4 = 7,8,9
Is there a formula that I can put in the Validation Rule (under the Field Properties) or something to have this field be automatically determined? If not, will it only work in a query?? Is there a VBA for this?