<div>
Do you just want a count of the no of times the student appears in each table?<br />
<br />
Or the actual records?
</div>


Do you just want a count of the no of times the student appears in each table?

Or the actual records?

<div>
ok, i'm really kicking myself that I didn't think of this!! this is exactly what I needed<br />
thanks so so much :)
</div>


ok, i'm really kicking myself that I didn't think of this!! this is exactly what I needed
thanks so so much :)

<div>
<div class="content wysiwyg-content">
hello! <br />
i know that there's a way to do this - but i've never done it before... I have three tables - each keeps track of different information on students. the student is identified by a numeric studentID field in each table. <br />
i need to figure out how to search by studentID to see if there are records in any or all of these tables... that is to say, I'd like to be able to create a form and call a particular studentID - and have the system tell me what records there are in any or all of these three tables for that student. I'm playing around with this and just can't figure it out! <br />
thanks!!
</div>
</div>


hello! 
i know that there's a way to do this - but i've never done it before... I have three tables - each keeps track of different information on students. the student is identified by a numeric studentID field in each table. 
i need to figure out how to search by studentID to see if there are records in any or all of these tables... that is to say, I'd like to be able to create a form and call a particular studentID - and have the system tell me what records there are in any or all of these three tables for that student. I'm playing around with this and just can't figure it out! 
thanks!!

searching several tables for records

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.