[AccessD] compare record fields

Gustav,

thanks for your help.


Susan,

i believ that the duplicate wizard only works on two tables,
and gives as result only the field that isn't present in teh other table.
I need the two fields with the mismatch in one record.

Pedro Janssen



----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, October 27, 2004 12:59 PM
Subject: Re: [AccessD] compare record fields


> Hi Pedro
>
> > i have a table in which i would compare two fields in one record with
each other.
> > The result must be the record where one of the values don't match with
one another.
>
> > fieldA    fieldB  and several other fields
> > 00123     00123
> > 02345     02345
> > 06789     06689
>
>
> > result
>
> > fieldA   fieldB  and several other fields
> > 06789    06689
>
> That could be:
>
>   SELECT
>     *
>   FROM
>     tblTable
>   WHERE
>     FieldA<>FieldB;
>
>
> /gustav
>
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>