I have a table that contains 12 outcome fields (these are drop-down lists / combo boxes) and each outcome field has a related date field e.g. 'outcome 1' paid employment, 'outcome date 1' 01/04/19; 'outcome 2' accredited training, 'outcome date 2' 30/06.19
I'm trying to create a query that will return all outcomes achieved between two given dates i.e. I need to somehow include all 12 date columns in the query. Is this possible? Or can anyone think of a way around it?
Thanks for your help