A within query

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

Guest

I have a table that is designed to give me the dates that certificates are due to be renewed . I am trying to create a query that will let me know within 2 months of when the renewal is due. I must have lost my touch because this is extremely hard for me.
Right now I have "Now() And" under my renewal column. This gives me the current renewals due. I cannot make it give me the "within 60 days"
Am I going about this all wrong?
 
Between Date() And DateAdd("m",Date(),2)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Michelle said:
I have a table that is designed to give me the dates that certificates are
Click to expand...
due to be renewed . I am trying to create a query that will let me know
within 2 months of when the renewal is due. I must have lost my touch
because this is extremely hard for me.
Right now I have "Now() And" under my renewal column. This gives me the
Click to expand...
current renewals due. I cannot make it give me the "within 60 days"
 
Back
Top