I'D APPRECIATE SOME HELP WITH WHAT SHOULD BE A FAIRLY EASY TASK. I'VE GOT A STUDENT WHO HAS CREATED A DATABASE LISTING HER CD COLLECTION. SHE'S GOT TWO TABLES. ONE CONTAINS THE ARTIST'S NAMES AND THE OTHER, THE ACTUAL SONGS. SHE'D LIKE TO BE ABLE TO IDENTIFY THOSE CD'S WHERE THE ARTIST AND PRODUCER ARE THE SAME BY COMPARING THE CONTENTS OF EACH OF THESE FIELDS AND LISTING THE RESULT ON A QUERY. I'D APPRECIATE ANY ASSISTANCE THAT I CAN GET ON THIS ONE. THANKS.

I think you can do this:

If the artist name field and producer name field are in separate tables:

create a query with a link between those two fields.

If the fields are in the same table:

create a query, select the artist name field and then, in the criteria, put =[producer name field]

Fuga.