Sub Query

C

Confused

I am trying to construct a Query using anoither query and table. for each
employee in the Query there are multible entries in the Table. Currently the
Query shows all entries equal to the empNum and PosID but multilpe prioritys.
I want to select the Top 01 for prioity which will result in one record for
each employee in CurrPos Query

Here is the query

SELECT qryCurrPos.EmpNum, qryCurrPos.PosID, qryCurrPos.NumBlw,
TblStandBid.NumBlw, TblStandBid.Priority
FROM qryCurrPos INNER JOIN TblStandBid ON (qryCurrPos.PosID =
TblStandBid.PosID) AND (qryCurrPos.EmpNum = TblStandBid.EmpNum)
WHERE (((TblStandBid.NumBlw)<=[qryCurrPos]![NumBlw]))
ORDER BY qryCurrPos.EmpNum, TblStandBid.Priority;

Any assitance would be appreciated
 
Top