Data of Current Month from Last

Hello,

I looking for a query to get the of the current last year(February 2016) using Year and Month Field.

Something like below.

Please Login or Register  to view this content.

In a form, put a textbox for the date,(txtDate)
A button to open the query.
The query uses textbox in the query to get last year, DateAdd("yyyy",-1,txtDate)

Or even a combo box of months, a textbox for year for user to enter.
A hidden textbox ,txtDate would still assemble the full date...
TxtDate = cboMo & "\1\" & txtYr