Filter Before Date (1 Viewer)

I'll caveat this with I have zero working knowledge of vba & minimal experience of access.

I have two criteria, I can get it working on the first, so it filters for employee number with a wildcard search and returning everything if the box is blank:

DoCmd.ApplyFilter "", "[Employee Num] Like ""*"" & [Forms]![Emp]![EmpBox] & ""*""

I want to create one if their start date is below a date in the unbound box [Forms]![Emp]![StartDateBox] and will return all employees if the [StartDateBox] is empty.

Hi Jamie. Welcome to AWF!

The usual approach would have the following syntax:

FieldName = Forms!FormName.ControlName OR Forms!FormName.ControlName Is Null

Thanks for the welcome and response,

Is there a way to integrate the two?

Filter based on the employee number if one is entered and/or the start date if a date is entered?

JamiePMortimer said:

Thanks for the welcome and response,

Is there a way to integrate the two?

Filter based on the employee number if one is entered and/or the start date if a date is entered?

Click to expand...

Yes, you just have to isolate the two separate conditions using parentheses. For example:
Hope that helps...