Hi guys, I have design a report based on a query. The report groups data per month and date.
In order the make things very simple for users, i designed a form and placed 3 comboxbox (CboYear, CboMonth, CboProduct) then 2 buttons (CmdViewReport, CmdClear).
Now i want to filter the report based based on the criteria that selected from the combobox.
I have managed to make the month and the product part work. But can't get the year part to work.
I have attached a demo access database file so that you have a look at what i did.
demo.zipPlease can someone help?
Thanks in advance.