Avatar of SteveL13
SteveL13
Flag for United States of America

asked on 

Trying to get query to work the way I want it to work

I have a form with three fields... a start date, an end date, and an employee combobox.  Then I have a query that has this syntax in the Date field:
Between [Forms]![frmTimeReportingHeader]![txtStartDate] And [Forms]![frmTimeReportingHeader]![txtEndDate]

Open in new window

But in the employee field I either want the record narrowed to the selection on the employee combobox.  This syntax works fine:
[Forms]![frmTimeReportingHeader]![cboEmployee]

Open in new window

But I cannot figure out what the employee syntax should be if I want all employees.
Microsoft Access

Avatar of undefined
Last Comment
SteveL13

8/22/2022 - Mon