Export data from table to Excel filtered by a field

[snowygirl1]

I have a few tables set up with information relating to people enrolled in a course.
I have created a query to pull the relevant information from various tables into one query which i then need to be able to export to Excel but need to be able to only export based on a specific course intake. E.g. there are 4 or 5 intakes per year, I need to be able to export just the information for Jan 2016 intake, as an example.



I was thinking would be useful to be have a form with a drop down menu, populated by the intake date in one of the tables, and I could just select the intake I wish to view and maybe run a query for just that intake, but I'm not sure how to go about doing that.

Can anyone give me some guidance on how I'd do this?

[ranman256]

Make the form, the combo activates the filter on a query to be exported.
the query;qsExportData
select * from table where [field]=forms!myForm!cboBox

Then export: docmd.transferspreadsheet .....qsExportData....