Basic query but filtered from a related tables value...?

[zozew]

I have another post about another query question but same db...this is another Question

Base:
3 tables linked like this:

Data Table 1 (tblInmatesProfile):
InmateID, Name, etc

Data Table 2 (tblInmateCases):
CaseID, InmateID, Branch, Crime, Etc

Data Table 3 (tblInmateHearings)
CaseID, HearingID, Hearings

Question
How would i filter the first table's data on the third tables Hearings field?

So i could choose a date and all records in the first table that has a record with that date (in the related table 3) would display?

 

[John Big Booty]

The SQL for the query would look something along the lines of;

SELECT tblInmateHearings.HearingDate, tblInmatesProfile.InmateName
FROM (tblInmateHearings INNER JOIN tblInmateCases ON tblInmateHearings.CaseID = tblInmateCases.CaseID) INNER JOIN tblInmatesProfile ON tblInmateCases.InmateID = tblInmatesProfile.InmateID
WHERE (((tblInmateHearings.HearingDate) Between #1/30/2010# And #2/10/2010#));

 

[zozew]

haha! It works like a charm...Thanks a million im starting to understand how you relate tables now in SQL queries.

Thx again