nickrugado
MIS
I have two queries one that pulls a record in the current year with an EffDate of 5/1/12 and the other query for the previous year that has multiple rows.
I want to find which of those 6 records was the one that was active 1 year ago using the EffDate from the current year query.
Anyone have any ideas, I have one that will require a lot of other work, I'm hoping this can be accomplished in a query.
I should also mention that what's pictured below is only 1 Key, where there will be a list of approx 100 individual records in the Current Year and Multiples in the Previous.
Thanks,
Nick
I want to find which of those 6 records was the one that was active 1 year ago using the EffDate from the current year query.
Anyone have any ideas, I have one that will require a lot of other work, I'm hoping this can be accomplished in a query.
I should also mention that what's pictured below is only 1 Key, where there will be a list of approx 100 individual records in the Current Year and Multiples in the Previous.
Thanks,
Nick