I'm trying to set the recordset for

[EddyLLC]

I'm trying to set the recordset for a form to show all leases that renewed the previous month. For example it is now January if I open the form I want the recordset to show all leases that renewed in December, next month, February, I want the forms recordset to list all leases that renewed in January, etc...

I'm currently using a query to load the forms recordset and as a criteria for the renewal date field I am using the following:

DatePart("m",Date())-1

This returns no records yet if I change remove the "-1" it returns all renewals for this month. If I replace "-1" with "+1", it correctly returns all renewals the will occur in February.

I cant seem to look back. Could this be because last month was a different year?

Thanks so much for the help.

 

[PHV]

What is the SQL code of the query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[randy700]

Could be, since Date is a reserved word, you need to:
1. Change the field name (recommended)
2. Use brackets [Date]



Randy

 

[dhookom]

This expression DatePart("m",Date())-1 will return a value between 0 and 11. Is that what you want?

Duane
Hook'D on Access
MS Access MVP