I have a database of individuals information. one of the sections is Holidays submitted. So each individual has a record of any past or planned holidays.
i would like to product a report that displays either Christmas, Easter or Summer holidays dependant on what is selected in a combobox i have set up.
The data i have is as follows:
Description (contains set data of "Christmas", "Easter" and "Summer")
Datefrom (Medium date)
DateTo (Medium date)
my problem is; if i produce a query and then report based on the description the report will include ALL returns past and present for that description. How do i restrict it to only forethcoming events dependant on the description selected.