K
knowshowrosegrows
I have a query with two parameters. One is a date range and the other is the
region (Region 1 through Region5). They trigger this query in a param form.
In the drop down they use to choose what region they want to search by, I
want a option of all regions. I don't know how to give them that option in
the drop down or in the SQL of the query.
The current SQL language follows:
SELECT qryEventsInfo.Reg, qryEventsInfo.Agency, qryEventsInfo.Type,
qryEventsInfo.EventDate, qryEventsInfo.StartTime, qryEventsInfo.StaffName,
qryEventsInfo.EventDescription, qryEventsInfo.ReportSubmitted,
qryEventsInfo.Notes
FROM qryEventsInfo
WHERE (((qryEventsInfo.Reg)=[Enter Region]) AND ((qryEventsInfo.EventDate)
Between [Starting Date] And [Ending Date]));
region (Region 1 through Region5). They trigger this query in a param form.
In the drop down they use to choose what region they want to search by, I
want a option of all regions. I don't know how to give them that option in
the drop down or in the SQL of the query.
The current SQL language follows:
SELECT qryEventsInfo.Reg, qryEventsInfo.Agency, qryEventsInfo.Type,
qryEventsInfo.EventDate, qryEventsInfo.StartTime, qryEventsInfo.StaffName,
qryEventsInfo.EventDescription, qryEventsInfo.ReportSubmitted,
qryEventsInfo.Notes
FROM qryEventsInfo
WHERE (((qryEventsInfo.Reg)=[Enter Region]) AND ((qryEventsInfo.EventDate)
Between [Starting Date] And [Ending Date]));