RE: Queries

From: Brandon Campbell (BrandonCampbell_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 09:44:22 -0700

Hi,

If you could post the SQL string, we could analyze the problem. But I a willing to venture that the criteria you are searching on is from the table that does not have a value for that column. Look to see if the column you are searching on is on the left outer join vs the right outer join.

Brandon 

-- 
--------------------------------------------
Database Administrator
bkc5  AT  CDC  dot   GOV
"bmersereau@zelle.com" wrote:
> I am creating a QC db.  I have a tbl where all the request data is stored and I have a tbl for the QC data is stored on type  of request.  Both tbls are linked by the service request number.  I want to be able to see results tied to a specific type of request.  Easy enough, however because there is no data in the QC tbl.  So I have a qry that has both tbls linked by request id and all fields are available.  When I run the qry solely on the service request tbl I of course see eveything, great.  When I join the tbls and set the join type to 2, I again see everything.  However when I enter criteria to only show me the a specific request type, I get nothing.
> (FYI the request type field is a dropdown field)
> 
> What I want is to have a QC frm based on this qry.  So that when I go to this specific QC form it will show me all the service request data tied to this type of request so that I can then complete the QC form.  Any suggestions?