hello everyone
I have three fields in a query PROGRAMTITLE, STARTDATE, ENDDATE. all of them from one table.
Sometimes there might be no enddates for events which means they continue for an unspecified period or continuing everyday.
My problems is when i ask the query to select events happening on a particular day its ignoring the events with empty/null enddate records.
How can i make a query so that it selects all the records (even nulls) if it matches the startdate.
hope im clear
any help would be appreciated
ahmed
I have three fields in a query PROGRAMTITLE, STARTDATE, ENDDATE. all of them from one table.
Sometimes there might be no enddates for events which means they continue for an unspecified period or continuing everyday.
My problems is when i ask the query to select events happening on a particular day its ignoring the events with empty/null enddate records.
How can i make a query so that it selects all the records (even nulls) if it matches the startdate.
hope im clear
any help would be appreciated
ahmed