Filter By date

[stirlingmw]

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.

 

[SydneyGeek]

Pull the DateFrom field onto the grid a second time.
In the Criteria put >=Date()
Unclick the Show checkbox, so the field merely gets used for criteria and doesn't display a second time.

Denis

 

[stirlingmw]

Fantastic thank you.I have a "Holidays" Frm which was created from "Holidays" Qry which includes the >=Date() criteria with the following cells:Reason (Value List)DateFromDateToSurnameAt the top of this form a have an Unbound Combobox with "Christmas";"Easter";"Summer" as a Value List (which is the same as "Reason")what i am trying to do is generate a Report based on the unbound combobox selection which filters the query based on the "Reason" selected