Query problem!!

  • Thread starter Thread starter edo
  • Start date Start date
E

edo

I have multiple tabs with a list of selected genes. Each tab include
fields: [Block] [Column] [Row] [Name]
I want the query to compare everyone of this fields in each tabs and
select (and show) only the records which are present in all the tabs.

How can I do this?
Thanks for your help!!
 
I have multiple tabs with a list of selected genes. Each tab include
fields: [Block] [Column] [Row] [Name]
I want the query to compare everyone of this fields in each tabs and
select (and show) only the records which are present in all the tabs.

How can I do this?
Thanks for your help!!
Click to expand...

By "Tabs" do you mean Tables? If you have multiple tables with the
same structure, your table design is flawed. Storing data in a
tablename is never a good idea!

If that is the case, you will need to create a Query. Add all of the
tables to the query; link each table to the next table by all four
fields. If you have very many tables you will probably get an error
("Query Too Complex"); if this happens, you will probably need to
restructure your tables into one large table with an additional field
identifying which table it's from. With this structure a very simple
Totals query can give you the desired result.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top