Hi,

I am trying to run a query to retrieve all rows in all tables using a row called Project Status. I am however not able to retrieve any data what so ever with the wizard and by using the limited sql I know. I have attached a copy of my tables if it helps.

The relationships are as follows: Release to PCR - One to many, Sponsors to PCR - One to many. The column i want to filter on is Project_status located in the PCR table.

Does anyone have any ideas how i can do this plz?

Thanks in advance for any help!

Ket

Open the query design grid. Add in your three tables. If the joins are not created automatically, join the tables on the PK/FK links. Drag to the grid whichever fields you need to see including Project Status. Add a criterion to the Project Status field to select whichever value you want.