Searching through Multiple Tables in Access 2003

By id4360 ·

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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums