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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Interesting Crosstab 1
Query Design 1
Excluding data from a query 3
IIf statement in query criteria 3
Dcount returning no results!!! 0
Update Query 10
Date range in a query 1
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0

Back
Top