Querying multiple fields

[Brockie]

I have a small database to manage debt recovery and wish to run a query to ascertain if anyone is due to make a payment on todays date. For example, I have 10 fields for dates that payments are due and wish to query them to see if todays date lands on any of them. I tried using the OR function but putting date() seems to return nothing, presumably because the criteria is to include todays date in all the fields, which is never the case. Any help would be appreciated, Cheers.

[Brockie]

Sorted now, thanks

[Homegrownandy]

Hello, I think your structure needs improving. The payments due should be separate from the "parent" record. each payment that is due should be its own record. You wouldn't have this issue then.

[Homegrownandy]

deleted- double post.