Query Help

[Charlie]

I am trying to produce a query that will produce all the selected treatment records for one patient only in my test database.
I am trying to edit an Access produced query to do this job for me, the query as it stands produces a list of all the patients who have received treatment and by who etc. as I explained before I only want one particular record. This is my query in SQL:

SELECT tblTreatment.TreatmentHistoryID, tblNurses.NurseID, tblNurses.Title AS tblNurses_Title, tblNurses.NFirst_Name, tblNurses.NSurname, tblDoctors.DoctorID, tblDoctors.Title AS tblDoctors_Title, tblDoctors.First_Name, tblDoctors.Surname
FROM tblTreatment INNER JOIN (tblDoctors INNER JOIN (tblNurses INNER JOIN tblInPatients ON tblNurses.NurseID = tblInPatients.NurseID) ON tblDoctors.DoctorID = tblInPatients.DoctorID) ON tblTreatment.TreatmentHistoryID = tblInPatients.TreatmentID;

I have tried adding WHERE [FirstName] = "Jack" but this produces a line of blnk cells.
would someone show me what my problem is.

Thanks
Charlie

 

[Parra]

Eliminate the Where expression

In the row below that where it says criteria type: like "jack". And make sure the show option is checked off.

The "Where" expression will get you the information you are requesting but will hide the column.

 

[Charlie]

Thanks

I dont know how to tell you this, I solved it myself a short time ago. The BIG error I made was that I was searching for a non existent criteria, I did not include the patient name in the query merely the patient ID so I should have been looking for the number 1.
Quite simply "I fu**ed up", sorry if I wasted your time. I liked the info about the missing column though, very useful.
Appreciate the effort.
Well played mate.

Charlie