Two tables where one value is not like the other.`

  • Thread starter Thread starter Tbride00
  • Start date Start date
T

Tbride00

I have two tableswhere I want to identify where one field
may or may not change from month to month. I would like
to identify what expression I need to enter to obtain this
data. For instance... Table 1 County 1 is not equal to
table 2 County 1. Any assistance would be greatly
appreciated. Thanks.
 
I have two tableswhere I want to identify where one field
may or may not change from month to month. I would like
to identify what expression I need to enter to obtain this
data. For instance... Table 1 County 1 is not equal to
table 2 County 1. Any assistance would be greatly
appreciated. Thanks.
Click to expand...

How are the tables related? Is there any field you can use to link the
tables? Otherwise Access must compare every record in Table1 against
every record in Table2, and I'd presume that LOTS of those comparisons
would have different counties!
 
The two table have a common ID... however the county codes
may change month to month. I would like to identify those
that do change.

Currently I have the following expression in place, but
know it's not correct:

Expr1: [TOTPCP Feb 04.COUNTY ID]<>[TOTPCP Mar 04.COUNTY ID]

I want it to read [TOTPCP Feb 04. CountyID] is not =
[TOTPCP Mar 04. CountyID] what type of expression do I
enter to obtain the output I want?
 
The two table have a common ID... however the county codes
may change month to month. I would like to identify those
that do change.

Currently I have the following expression in place, but
know it's not correct:

Expr1: [TOTPCP Feb 04.COUNTY ID]<>[TOTPCP Mar 04.COUNTY ID]

I want it to read [TOTPCP Feb 04. CountyID] is not =
[TOTPCP Mar 04. CountyID] what type of expression do I
enter to obtain the output I want?
Click to expand...

You're almost there - the problem is that the square brackets should
enclose the table name and the field name separately. You're telling
Access that it's all one big fieldname, and it can't find that name!

Create a Query joining the two tables by the unique ID and use a
criterion on [TOTPCP Mar 04].[COUNTY ID] of

<> [TOTPCP Feb 04].[COUNTY ID]

or your expression would work too, if you use
[TOTPCP Feb 04].[COUNTY ID]<>[TOTPCP Mar 04].[COUNTY ID]

with a criterion of True.

I must express a concern that having tables with data (dates) in the
tablename is *very* bad design and should be avoided if at all
possible!
 
Back
Top