Expression looking back in time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I need help in writing an expression in a criteria in a
query. My boss wants vintage information looking back 3 6
9 12 18 24 months from a, first payment due date (I work
as a reporting person in the mortgage industry). Could
someone please help me write an expression for that or
tell me the steps?

Thanks,
Mike
 
Between DateAdd("m", -[Enter the number of months to look back:], [Enter the
First Payment Date:]) And [Enter the First Payment Date:]
 
Back
Top