I'm new to access and have a question please.
I have a table EZExtract with a few fields, some of which:
ItemID
DatePaidDate
DateofBirth
I want to replicate the whole table amending the ItemID fields based on the following conditions:
If ItemID = 2
Then
Work out the age in Months (would be something along the lines of DateofBirth - DatePaidDate / 12)
Then
If Age in Months < 6 ItemID = EZ1000
If Age in Months Between 7 and 12 ItemID =EZ1001
If Age in Months Between 13 and 36 ItemID =EZ1002
If Age in Months Between 37 and 132 ItemID =EZ1003
If Age in Months >133 ItemID =EZ1004
Any idea how I can do this please (again, i'm new to access).
Thanks for taking the time to read my question.