SubQuery???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try and make the query into a group by query and change the Priority field
from group by to Min or Max, depend on the value you like to have.
 
Back
Top