Software

Ask something
Question Locked

Searching through Multiple Tables in Access 2003

0 helpful
2 replies

by id4360

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I have a database, which has information on students from various academic years. Some of the fields in the tables are not the same. I cannot combine them because of dept. policy and also because of some fields being different. The issue is if I want to look up a student I have to search in each and every table.

So I wanted to find a way to be able to type the criteria which is the ID # (this field is there in every table), or the last name (also there in every table), in a box or space. And when I press search, it searches in all the tables and ouputs all the info abt the student, and also the table they belong. I am hoping that there won't be data that exist in more than one table

So is this doable? if so how could I do it?

2 replies

by beverly413

I have the same question except its vehicles, not students. The ID is consistent between all the tables.

This discussion is closed to new replies.