I have a query which looks for records in a table containing one of 5 codes
where its between a date range, currently if only 4 codes are used in this
date range it only returns 4 results.  Is there a way I can get it to return
all 5 results regardless of whether one is a null value?



NOTICE AND DISCLAIMER:
This email (including attachments) is confidential.  If you have received
this email in error please notify the sender immediately and delete this
email from your system without copying or disseminating it or placing any
reliance upon its contents.  We cannot accept liability for any breaches of
confidence arising through use of email.  Any opinions expressed in this
email (including attachments) are those of the author and do not necessarily
reflect our opinions.  We will not accept responsibility for any commitments
made by our employees outside the scope of our business.  We do not warrant
the accuracy or completeness of such information.

Ben,

<< I have a query which looks for records in a table containing one of 5 
codes where its between a date range, currently if only 4 codes are used 
in this date range it only returns 4 results.  Is there a way I can get it 
to return all 5 results regardless of whether one is a null value? >>

Could you please give us an example of the codes and also elaborate on 
what exactly you're looking for?  Thanks.

Greg

Sorry to waste your time Gregory, I was being dim, I've sorted it now.

-----Original Message-----
From: Gregory Serrano [mailto:SerranoG@m...]
Sent: 30 October 2002 13:13
To: Access
Subject: [access] Re: Queries


Ben,

<< I have a query which looks for records in a table containing one of 5 
codes where its between a date range, currently if only 4 codes are used 
in this date range it only returns 4 results.  Is there a way I can get it 
to return all 5 results regardless of whether one is a null value? >>

Could you please give us an example of the codes and also elaborate on 
what exactly you're looking for?  Thanks.

Greg




NOTICE AND DISCLAIMER:
This email (including attachments) is confidential.  If you have received
this email in error please notify the sender immediately and delete this
email from your system without copying or disseminating it or placing any
reliance upon its contents.  We cannot accept liability for any breaches of
confidence arising through use of email.  Any opinions expressed in this
email (including attachments) are those of the author and do not necessarily
reflect our opinions.  We will not accept responsibility for any commitments
made by our employees outside the scope of our business.  We do not warrant
the accuracy or completeness of such information.

You need to change the JOIN from an INNER JOIN to an OUTER JOIN.  If 
you are
using the query designer, right click on the line joining the two 
tables and
select Join Properties.  Then select the option to show all records 
from the
table with the null values.  Then re-run the query.

Rand E Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston IL 60201
(xxx) xxx-xxxx

-----Original Message-----
From: Ben Mildren [mailto:Ben.Mildren@t...]
Sent: Wednesday, October 30, 2002 05:44
To: Access
Subject: [access] Queries


I have a query which looks for records in a table containing one of 5 
codes
where its between a date range, currently if only 4 codes are used in 
this
date range it only returns 4 results.  Is there a way I can get it to 
return
all 5 results regardless of whether one is a null value?



NOTICE AND DISCLAIMER:
This email (including attachments) is confidential.  If you have 
received
this email in error please notify the sender immediately and delete 
this
email from your system without copying or disseminating it or placing 
any
reliance upon its contents.  We cannot accept liability for any 
breaches of
confidence arising through use of email.  Any opinions expressed in 
this
email (including attachments) are those of the author and do not 
necessarily
reflect our opinions.  We will not accept responsibility for any 
commitments
made by our employees outside the scope of our business.  We do not 
warrant
the accuracy or completeness of such information.