Hi again all.
I have a report (StaffRecord) that is based on a query. The query has two set of criteria necessary to select the correct staff member and date details.The query selects an individuals record [StaffName] and runs between selected dates [Start Date] and [End Date].
I have an unbound form (StaffSelectForm) that displays the names of the staff [StaffName], a [Start Date] and an [End Date]. The user is to select a staff name from the cbo box, then enter a start and end date, click a command button, and have the report run, based on the query with the staff/date details.
What do I put in the query (criteria) that makes the query get the [StaffName], [Start Date] and [End Date] information from the form.
Additionally, if no date is selected, I want all records for that person to be displayed.
Any help appreciated.