Query help

[rhett7660]

Criteria query help

I have a query that works fine (based of a table).

I have different job titles that I want it show me, however i only want to see jobs 5-10 not 1-4.

My table looks like this:

1.Service Center
2.Computer Tech
3.Computer Sales
4.Manager
5.Supervisor
6.Supervisor Tech

I only want to see jobs 4, 5, 6. How can I do this?

Here is the sql that I am currently working with:

SELECT tblApplicant.ApplicantID, tblApplicant.InvestigatorID, tblApplicant.AppLName, tblApplicant.AppFName, tblApplicant.AppMInitial, tblApplicant.SocNumber, tblApplicant.Status, tblApplicant.Active, tblApplicant.ReasonForInactive, tblApplicant.EndResult, tblApplicant.EndResultMemo, tblApplicant.FOSLName, tblApplicant.FOSRank, tblApplicant.DateAssigned, lutblRank.RankID, lutblRank.Rank
FROM tblApplicant INNER JOIN lutblRank ON tblApplicant.FOSRank = lutblRank.RankID
WHERE (((lutblRank.RankID)=[Forms]![frmReports]![cboRank]));

This is the code that I am using to select each job and display all that are in the job catagory. What I want is to see all the job titles of 4,5 and 6 only.

Thanks
R~

 

[KeithG]

SELECT tblApplicant.ApplicantID, tblApplicant.InvestigatorID, tblApplicant.AppLName, tblApplicant.AppFName, tblApplicant.AppMInitial, tblApplicant.SocNumber, tblApplicant.Status, tblApplicant.Active, tblApplicant.ReasonForInactive, tblApplicant.EndResult, tblApplicant.EndResultMemo, tblApplicant.FOSLName, tblApplicant.FOSRank, tblApplicant.DateAssigned, lutblRank.RankID, lutblRank.Rank
FROM tblApplicant INNER JOIN lutblRank ON tblApplicant.FOSRank = lutblRank.RankID
WHERE (((lutblRank.RankID) between 4 and 6));

 

[rhett7660]

Keith...

Thank you very much, worked like a charm. I was trying out comma's etc... and it was the word "and".

Thank you again
R~