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?