[AccessD] Why does the query equate these two fields?

Kaup, Chester Chester_Kaup at kindermorgan.com
Tue Sep 19 14:50:14 CDT 2006


The query acts normally if I import the data rather than link to the SQL
server view. I don't know what to think about that.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Billy Pang
Sent: Tuesday, September 19, 2006 2:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Why does the query equate these two fields?

do you get the same result if you convert dbo_DSS_Wellmaster to a local
table?

On 9/19/06, Kaup, Chester <Chester_Kaup at kindermorgan.com> wrote:
>
> ConfigMaster is a local table. dbo_DSS_Wellmaster is SQL server
version
> 2007 table.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A
Matte
> Sent: Tuesday, September 19, 2006 1:30 PM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Why does the query equate these two fields?
>
> Chester,
>
> I recreated your scenario...but not you results.  In looking at my
> example...I have 1 question...
>
> Q:  Are "ConfigMaster" and "dbo_DSS_WellMaster" both tables in a local
> db...or are they queries/linked table/other?
>
> Thanks,
>
> Mark A. Matte
>
>
> >From: "Andy Lacey" <andy at minstersystems.co.uk>
> >Reply-To: Access Developers discussion and problem
> >solving<accessd at databaseadvisors.com>
> >To: "'Access Developers discussion and problem
> >solving'"<accessd at databaseadvisors.com>
> >Subject: Re: [AccessD] Why does the query equate these two fields?
> >Date: Tue, 19 Sep 2006 19:04:27 +0100
> >
> >Whoa that's weird. I've never seen that either. I can't suggest an
> >explanation but I'm going to be interested in the solution.
> >
> >-- Andy Lacey
> >http://www.minstersystems.co.uk
> >
> > > -----Original Message-----
> > > From: accessd-bounces at databaseadvisors.com
> > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> > > Kaup, Chester
> > > Sent: 19 September 2006 18:57
> > > To: Access Developers discussion and problem solving
> > > Subject: Re: [AccessD] Why does the query equate these two fields?
> > >
> > >
> > >
> > >
> > > Lets try this again. Message reformatted itself.
> > >
> > >
> > > The contents of the two joined text fields are not the same
> > > but the query equates them. Here is the query and the
> > > results. Never seen this before.
> > >
> > >  SELECT DISTINCT ConfigMaster.PID AS CO2PAT,
> > > ConfigMaster.ChildPID, dbo_DSS_WellMaster.PID
> > >
> > > FROM ConfigMaster
> > >
> > > INNER JOIN dbo_DSS_WellMaster ON ConfigMaster.ChildPID =
> > > dbo_DSS_WellMaster.PID
> > >
> > > WHERE (((ConfigMaster.PID)="PAT 101-1"))
> > >
> > > ORDER BY ConfigMaster.PID;
> > >
> > >
> > > CO2PAT              ChildPID                PID
> > > PAT 101-1           42415016740001  4241501674
> > > PAT 101-1           42415016770001  4241501677
> > > PAT 101-1           42415017470001  4241501747
> > > PAT 101-1           42415017490001  4241501749
> > > PAT 101-1           42415017610001  4241501761
> > >
> > >
> > >
> > >
> > > Chester Kaup
> > > Engineering Technician
> > > Kinder Morgan CO2 Company, LLP
> > > Office (432) 688-3797
> > > FAX (432) 688-3799
> > >
> > >
> > >
> > >
> > >
> > > No trees were killed in the sending of this message. However
> > > a large number of electrons were terribly inconvenienced.
> > >
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > >
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > >
> >
> >
> >--
> >AccessD mailing list
> >AccessD at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/accessd
> >Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Billy Pang
http://dbnotes.blogspot.com/
"Once the game is over, the King and the pawn go back in the same box."
-
Italian proverb
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list