K kitty77 Registered User. Local time Today, 09:16 Joined May 27, 2019 Messages 719 Oct 16, 2023 #1 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?
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 bit cruncher Local time Today, 06:16 Joined Mar 17, 2004 Messages 8,577 Oct 16, 2023 #2 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?
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?