I have 32000 records in my table and I need my monthly report to show me all records for the month of June 2016 for example, or January 2015, just by selecting "January 2015" from combo box. This combo box needs to be sequentially populated when opening a report and if a new month is detected to add it to combo box.
Any help is appreciated.
select format([dateField], "mmmm yyyy") from tableName
group by format([dateField], "mmmm yyyy")
order by [dateField]
use a query as recordsource of your form/report using the value of the selected item form the combo box
select * from tableName
where format([dateField], "mmmm yyyy") = Forms!NameofForm.NameofCom