date field match (1 Viewer)

[kitty77]

I have a form that has four fields, date fields.
I would like to find the records where any of those four fields match?

What is the best way to approach this?

 

[MarkK]

This sounds like a normalization problem. If the four dates were in separate rows, for instance, this problem would be trivial. Can you describe your requirement in greater detail?

 

[Pat Hartman]

I would make a function so I could use an array and VBA. But, the best option as always is normalizing the data