Creating an Access Query...

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

I have a created a database containing 12 tables. These
tables are called January, February, March etc and contain
the addresses of people who have sent in mail for that
month .

What i would like to do is create a query to search all of
these tables and identify any duplicate addresses, so i
would know if any of the senders have sent in mail in a
preceding month.

Thanks for nay help in this matter.
 
-----Original Message-----
I have a created a database containing 12 tables. These
tables are called January, February, March etc and contain
the addresses of people who have sent in mail for that
month .

What i would like to do is create a query to search all of
these tables and identify any duplicate addresses, so i
would know if any of the senders have sent in mail in a
preceding month.

Thanks for nay help in this matter.
.
hi joe.
Click to expand...
what you really need to do is normalize your table design.

all your people should be listed in one table, with one
entry for each person (or household, perhaps, depends on
the nature of your data). that will be what is called
a "parent" table. make sure you include a Primary Key
field, such as an AutoNumber field, or another piece of
data that uniquely identifies each record.

then create another table. include one field that is the
same as the primary key field in the parent table. include
another field for the month. this is your "child" table.

now create a one-to-many relationship between the parent
and child tables.

now you can add a record to the child table every time a
person in the parent table sends in mail. this design will
allow you to easily create queries/reports that will show
who is sending what, and when.

if you'd like more detail, you can email me and i'll help
you.
 
Back
Top