Select Query problems

  • Thread starter Thread starter M.Garza
  • Start date Start date
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!
 
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...
 
Back
Top