This will be my first ask for help here;)
I'm working on a database at the moment and have exhausted my resources on this one.
I have a report with an underlying muti-table query. The report uses an input box to set the date criteria rather than Parameter boxes to show the relevant records from to these dates.
and then I've used
Between [Forms]![frmMonthlyDisbursalDialog]![StartDate] And [Forms]![frmMonthlyDisbursalDialog]![EndDate]
within the query to reference to the dates seleted within the input box All is working well here.
My question is. If I wanted to use just the Month and Year as criteria, so that I would, perhaps, just have a drop down month combo box and a control for the year. Is it possible to extract the records for that month rather than typing in the exact date to that day?. Or maybe something similar to this technique?
All my other attemps have failed. Hope someone can help.