Duplicate Description Field

  • Thread starter Thread starter Diane Walker
  • Start date Start date
D

Diane Walker

I am running Access 2003. I want to compare the Description field of two
tables. If the Description field is different, I want to output the
records. If the Description field is the same, don't output the records.
Is there a way to set it up? Please let me know if you need additional
information. Thanks.
 
Diane, set up your query with the fields you want, either by writing the sql
or by using the query builder. Join the two tables on whatever field makes
sense to join them on. Then, if you are writing SQL, add
WHERE table1.Description <> table2.Description
to your SQL.
.. If using the query builder, put
<> [table2].[description]
in the criteria box under table1.description

hth
-John
 
John,

Thank you very much for your quick response.

I use Query Builder and put "<>[table2].[description]" in the criteria box
under table1.description. When I run it, it prompted a screen "Enter
Parameter Value". What am I doing wrong? Thanks.

John Welch said:
Diane, set up your query with the fields you want, either by writing the
sql or by using the query builder. Join the two tables on whatever field
makes sense to join them on. Then, if you are writing SQL, add
WHERE table1.Description <> table2.Description
to your SQL.
. If using the query builder, put
<> [table2].[description]
in the criteria box under table1.description

hth
-John

Diane Walker said:
I am running Access 2003. I want to compare the Description field of two
tables. If the Description field is different, I want to output the
records. If the Description field is the same, don't output the records.
Is there a way to set it up? Please let me know if you need additional
information. Thanks.
Click to expand...
Click to expand...
 
You have to replace 'table2' with the name of your other table, and
'description' with the name of the description field. And don't put quotes
just in case you did.
-John

Diane Walker said:
John,

Thank you very much for your quick response.

I use Query Builder and put "<>[table2].[description]" in the criteria box
under table1.description. When I run it, it prompted a screen "Enter
Parameter Value". What am I doing wrong? Thanks.

John Welch said:
Diane, set up your query with the fields you want, either by writing the
sql or by using the query builder. Join the two tables on whatever field
makes sense to join them on. Then, if you are writing SQL, add
WHERE table1.Description <> table2.Description
to your SQL.
. If using the query builder, put
<> [table2].[description]
in the criteria box under table1.description

hth
-John

Diane Walker said:
I am running Access 2003. I want to compare the Description field of
two tables. If the Description field is different, I want to output the
records. If the Description field is the same, don't output the records.
Is there a way to set it up? Please let me know if you need additional
information. Thanks.
Click to expand...
Click to expand...
Click to expand...
 
John,

I apologize. Sorry for the inconvenience. Your instruction is now working.
I don't know why it did not work the first time.

Thanks.

John Welch said:
You have to replace 'table2' with the name of your other table, and
'description' with the name of the description field. And don't put quotes
just in case you did.
-John

Diane Walker said:
John,

Thank you very much for your quick response.

I use Query Builder and put "<>[table2].[description]" in the criteria
box under table1.description. When I run it, it prompted a screen "Enter
Parameter Value". What am I doing wrong? Thanks.

John Welch said:
Diane, set up your query with the fields you want, either by writing the
sql or by using the query builder. Join the two tables on whatever field
makes sense to join them on. Then, if you are writing SQL, add
WHERE table1.Description <> table2.Description
to your SQL.
. If using the query builder, put
<> [table2].[description]
in the criteria box under table1.description

hth
-John

I am running Access 2003. I want to compare the Description field of
two tables. If the Description field is different, I want to output
the records. If the Description field is the same, don't output the
records. Is there a way to set it up? Please let me know if you need
additional information. Thanks.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top