[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