two tables

[Guest]

Hi all

I have an access database with two tables (ok not very impressive!!).
However the two tables are not link with a relationship. The two table have
almost identical data (in term of address) apart from one field (with a yes
or no). The tables are for two separate months but the same area.

However although not linked, is it possible to use a query that will tell me
which of the fields do not match (the yes and no's) for the two months.

Any help appreciated.

Rexmann

Ps it is Access 2000

 

[Guest]

You have two tables where potentially each will have a row where the address
may say 123 N 4th Street or one might be 123 North 4th St. You want to know
if the Yes/No for this address matches on both tables.

You can set a query level relationship so that you have a basis on which to
join. If the scenario above applies, you won't find anything as the two
don't match. If the data in both tables match, the you can join the two
tables and look at the Yes/No value in each.

It sounds like your real issue is a design one. If you are getting data
each month about the same entities, the entity data should live in one table
and the Yes/No or whatever other data in another table where you have the
entity ID and Month plus whatever other data are relevant on a monthly basis.

 

[Guest]

Hi thanks DevalilaJohn

I think you are right. I inherited the tables from someone who left so I
think a bit of redesign is in order.

cheers Rexmann