Unanswered: Lost writing a query...
Got a query I'm trying to write and not getting anywhere with it...
I have an event table that has, for instance, holidays. The query I'm trying to write is one that has a day of the month and any "event" that will fall on that day. So, for July, I might get:
In my events table, I have a begin date and an end date for events such as Thanksgiving holiday... which spans multiple days. So, I'm trying to write a query that would return, for November, something like this:
4 Independence Day (USA)
My EVENTS table has columns EVENT_NAME, BEGIN_DATE, END_DATE... any ideas how to write the query?
22 Thanksgiving (USA)
23 Thanksgiving (USA)
save disk space, use smaller fonts