Select Query problems

M

M.Garza

Hello, I need some help. I have a query that returns records based on
a date range; that works fine. The problem is that if the date is
empty it won't return that record. I am using it to count buses that
have ads that willl expire within the date range specified but I also
need the available buses with no ads to display as well. How can I
make my query return all buses whether in the date range or no date?

Help!
 
M

M.Garza

Awesome! You just solved my three day dilemma and just in time for
the weekend. You rock!

Maria

Between [Enter start date] AND [Enter end date] OR Is NULL
--
KARL DEWEY
Build a little - Test a little



M.Garza said:
Hello, I need some help. I have a query that returns records based on
a date range; that works fine. The problem is that if the date is
empty it won't return that record. I am using it to count buses that
have ads that willl expire within the date range specified but I also
need the available buses with no ads to display as well. How can I
make my query return all buses whether in the date range or no date?
Click to expand...
Help!- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...
 
Top