Need help with a query with two MonthNumber fields (1 Viewer)

[gojets1721]

So without going into the specifics, I have a query with two fields which show two different date fields as Month Numbers.

What I'm trying to do is if a record's field2 does not have the same MonthNumber as field1, then I want that record to be excluded from the query. Any suggestions on how to do that?

 

[theDBguy]

Have you tried?

WHERE Field1 = Field2

 

[gojets1721]

Have you tried?

WHERE Field1 = Field2

That worked! Thank you

 

[theDBguy]

That worked! Thank you

You're welcome. Glad we could assist. Good luck with your project.