I made a report that show a list of data where there is a date. It sorts the report by year then by month.
I collects the information about the date from a field in a table where the whole date is inserted (example28.12.2014. (date/month/year)).
What I want is to make a combobox or a listbox where you would chose a year you want it to show you the report for and a button that would open the report.
So to make it clear in a form you would have a combobox where years would be displayed (and i would like the combobox to somehow know what years are inserted in the table), you select the year and click on the button that would open the report for that year.
I trully am blank on how to filter this so that is why i came here for help.
The report name is "rptClients". The table from where the data for report is taken is "tblCustomers" and the field where the date is in the table is called "DateOfUse".
Also in the report the date is in a field called "DateOfUse" also.
If anyone out there can help I would be thankful.
I collects the information about the date from a field in a table where the whole date is inserted (example28.12.2014. (date/month/year)).
What I want is to make a combobox or a listbox where you would chose a year you want it to show you the report for and a button that would open the report.
So to make it clear in a form you would have a combobox where years would be displayed (and i would like the combobox to somehow know what years are inserted in the table), you select the year and click on the button that would open the report for that year.
I trully am blank on how to filter this so that is why i came here for help.
The report name is "rptClients". The table from where the data for report is taken is "tblCustomers" and the field where the date is in the table is called "DateOfUse".
Also in the report the date is in a field called "DateOfUse" also.
If anyone out there can help I would be thankful.
