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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks