multiple criteria queries

[Guest]

I have two tables, both containing two of the same fields (neither primary or
unique). I need to add a field (C) from one of the tables where the two (A &
B) match. I can't get it to work...can someone help?

 

[Joseph Meehan]

I have two tables, both containing two of the same fields (neither
primary or unique). I need to add a field (C) from one of the tables
where the two (A & B) match. I can't get it to work...can someone
help?

I am a little confused, where are you adding the field from one table?

I suspect you may want to examine your data structure and review your
table structure. I sounds like you may need to re-design your tables.

 

[Guest]

Sorry, I need to add a field to a query that is dependant on two other fields.

 

[Joseph Meehan]

Sorry, I need to add a field to a query that is dependant on two
other fields.

Create a query. Base it on one table, put the fields you want in the
query. Next add the other table and like it by the field(s) in each table
that you want to match. Set the link to include only records where there
are matches.