[AccessD] compare two fields

Hello Charlotte,

I did this sql before and forgot the syntax for not equals. I tried "Is Not"
but as you noticed, that isn't valid.
Because i am using A2003 and find the help function terrible, i found it
more useful to ask the question at accessd.
<> is working perfect.

- Pedro Janssen -


----- Original Message -----
From: "Charlotte Foust" <cfoust at infostatsystems.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, January 17, 2005 5:19 PM
Subject: RE: [AccessD] compare two fields


> "Is Not" isn't valid syntax.  Are you referring to the not equals
> characters (<>)?
>
> Charlotte Foust
>
>
> -----Original Message-----
> From: pedro at plex.nl [mailto:pedro at plex.nl]
> Sent: Monday, January 17, 2005 7:34 AM
> To: AccessD at databaseadvisors.com
> Subject: Re: [AccessD] compare two fields
>
>
> Paul and Andy,
>
> thanks for responding.
> I tried to fil in "Is Not" , but that didn't work. We use A2003 and the
> help function, i think, is terrible. It takes to much time to find easy
> answers. Its quicker to ask at this list then the help function.
>
> Pedro Janssen
>
>
>
> In antwoord op:
>
> > From: "Andy Lacey" <andy at minstersystems.co.uk>
> > To: "Access Developers discussion and problem solving"
> > Date: Mon, 17 Jan 2005 10:49:10 +0100
> > Subject: Re: [AccessD] compare two fields
> >
> >
> > Watch out for Nulls. If your data may have Null in fields then try:
> >
> > SELECT FieldA, FieldB
> > FROM Table1
> > WHERE Nz(FieldA) <> Nz(FieldB)
> >
> > --
> > Andy Lacey
> > http://www.minstersystems.co.uk
> >
> >
> >
> > --------- Original Message --------
> > From: Access Developers discussion and problem solving
> > <accessd at databaseadvisors.com>
> > To: Access Developers discussion and problem solving
> > <accessd at databaseadvisors.com>
> > Subject: Re: [AccessD] compare two fields
> > Date: 17/01/05 10:31
> >
> > >
> > > This should give you what you want.
> > > SELECT Table1.FieldA, Table1.FieldB
> > > FROM Table1
> > > WHERE (((Table1.FieldA)&lt;&gt;[Table1.FieldB]))
> > > Paul Hartland
> > >
> > >
> > >
> > >
> > >
> > >
> > > Message date : Jan 17 2005, 10:24 AM
> > > &gt;From : pedro at plex.nl
> > > To : AccessD at databaseadvisors.com
> > > Copy to :
> > > Subject : [AccessD] compare two fields
> > > Hello group,
> > >
> > > is there a way to compare the values of two fields in one record Al
> > > the records where the values of the two fields don't match (in one
> > record) must be given in the result.
> > >
> > > I have done this before, but i can't find the sql.
> > >
> > > Thanks
> > >
> > > - Pedro Janssen -
> > >
> > > Example:
> > >
> > > Table1
> > >
> > > fieldA fieldB
> > >
> > > 012345 012345
> > > 456789 456789
> > > 234567 034567
> > >
> > > result
> > > 234567 034567
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > > --
> > >
> > > Whatever you Wanadoo:
> > > http://www.wanadoo.co.uk/time/
> > >
> > > This email has been checked for most known viruses - find out more
> > > at:
> > http://www.wanadoo.co.uk/help/id/7098.htm
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> > >
> > >
> > >
> > >
> > >
> >
> > ________________________________________________
> > Message sent using UebiMiau 2.7.2
> >
> > --
> > 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
>
>