accessing different tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I want to be able to access different tables but all the tables have the
same fields and I want to view the unique fields in this new query.

thanks
 
Different tables with the same fields? Sounds like a bad design. Why would
you have multiple tables with the same design? This is most commonly done
if the table name indicates the type of data in it. This is almost always a
bad idea. Instead, put all the data in one table and add a field to
differentiate the records. Most commonly a "type" or "category" or
"department" type of field would do the trick.

I any case, if you want a query that pulls all the records from all the
tables, a UNION query would do the trick. You'd have to explain a bit more
if you need more details. Your desire in your post is pretty vague.
 
tourbiek said:
Hi,
I want to be able to access different tables but all the tables have the
same fields and I want to view the unique fields in this new query.

thanks
Click to expand...

Not sure if I understand the question, but does this help:


You can specify the field name qualified by the table name.

eg If you had 2 tables

Table1
=====
Name
Id

Table2
======
Name
Id

You could write a query like:

Select [Table1].[Name], [Table2].[Name] from Table1,Table2
Where [Table1].[Id] = [Table2].[Id]

ChrisM.
 
I think there's a find unmatched records wizard which will do this.

HTH;

Amy
 
Hi there, well I need to explain more about the tables. Basically the main
problem comes from we need about 10 poeple to access and input data into the
database. So I have spilt up the table into different regions then while one
person works on that region other people will be working on other regions.
Basically what I then want is a overview of the tables listing all the names
of the people contain within the databases but then be able to filter out
repeat names as some poeple may be on the database 20 or more times.

thanks
 
Back
Top