MS Query Criteria with two fields if either contain a January date (1 Viewer)

[sdjames1979]

Hi

Basically, I have a table showing our clients and when their next service dates are:

I need the query to show NEXT SERVICE DUE dates in January, AND/OR if NEXT LOLER has any January dates.

These should show as either or both fields have January dates:

Next Service Due: February
Next LOLER: January

Next Service Due: January
Next LOLER: December

Next Service Due: January
Next LOLER: January
​

I managed to do the NEXT SERVICE DUE with January dates, but not both

Please help.

 

[Adam Caramon]

If I'm understanding you correctly, then you simply need to make use of the "or" criteria in the query builder.

 

[sdjames1979]

I've used the following as shown in the attached pic:

Month([Next Service Due:])
Critera: 1 (January dates)

but I also need to show any dates in the NEXT LOLER field.

 

[sdjames1979]

I think i've done it

Field: Expr2: Month([Next LOLER])
Or: 1

WOO HOO.