Filtering report based on another table

[sukhi]

Hi,

I am new to access and need some help. I have a report based on a table say "A", which contains a field called "Department" (along with other fields). Now I want to filter this field "Department" in my report based upon values stored in another table called "B". eg. department in table A contains "d1, d2, d3, d4" and table B contains "d2, d3". The report should show the values where department is d2 or d3. Any suggestions/help please??

Thanks.

 

[Pat Hartman]

Base the report on a query that joins the two tables. The "filter" table will restrict the number of rows returned in the query.

 

[sukhi]

Base the report on a query that joins the two tables. The "filter" table will restrict the number of rows returned in the query.

Thanks a lot for the help Pat! problem solved!!