Query Help needed please!

To Whom It May Concern:

I have a table with the following fields; dbo_Visits.Session_Hx_ID,
dbo_Visits.Visit_ID & dbo_Visits.Completed.

The database is setup so that you will have one dbo_Visits.Session_Hx_ID
that is associated with one or more dbo_Visits.Visit_IDs.

What I am trying to do is to exclude any dbo_Visits.Session_Hx_ID where the
associated dbo_Visits.Visit_ID does not contain -1 in dbo_Visits.Completed
field.

Sample data are as follows;

Session_Hx_ID Visit_ID Completed
914 2395 -1
915 2397 0
915 2420 0
915 2424 -1
915 2428 -1

Thank you f or your assistance.
.

Relevant Pages

  • Permission problem with ADOMD and AS2000
    ... If I copy the database and ASP.NET application to a different domain (using ... Account) to connect on one domain and not on the other? ... Is it a setup issue ... Prev by Date: ...
    (microsoft.public.sqlserver.olap)
  • Re: Report / Sub-Report Problerm
    ... Thank you very much for your assistance. ... solved my problem and I am now able to deliver this database to my ... client with the functionality they have requested. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: Importing from other application
    ... >> without going through all 10,174 lines in my database ... >> Thanks for any assistance! ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: BCM "database creation has failed" error
    ... microsoft.public.outlook.bcm for more specific assistance. ... > I am setup as Administrator ... > I cannot setup a database. ...
    (microsoft.public.outlook.contacts)
  • multiple criteria search page
    ... I am using the following code to search for records in my database: ... This works for a single field, is there a way to write the search so that I ... Thank you for any assistance. ... Prev by Date: ...
    (microsoft.public.access.formscoding)