Hi,
I have a table called EventData containing various fields including StartDay and Events. Some Events have multiple StartDays each of which are separate records.
Is it possible to run a query to return records that match a specified start day (eg Monday) but also have at least one other different start day? So, for example, if an Event only had a start day of Monday it would be excluded but if it had a start day of Monday and Tuesday it would be included.
I thought it would be easy but I can't work out how to do it.
Thanks
I have a table called EventData containing various fields including StartDay and Events. Some Events have multiple StartDays each of which are separate records.
Is it possible to run a query to return records that match a specified start day (eg Monday) but also have at least one other different start day? So, for example, if an Event only had a start day of Monday it would be excluded but if it had a start day of Monday and Tuesday it would be included.
I thought it would be easy but I can't work out how to do it.
Thanks