I have a query which retrieves a year's worth of data. In one of the fields I have a number which specifies how many month's a client has accrued.
So Client A may have accrued the last 3 months. So I only want to retrieve the last 3 months for him.
Client B may have accrued the last 6 months, so I only want to retrieve the last 6 months for them.
So Client A may have accrued the last 3 months. So I only want to retrieve the last 3 months for him.
Client B may have accrued the last 6 months, so I only want to retrieve the last 6 months for them.