I used the Query Designer in Access to create the following query:
SELECT Docs214.BOL, Docs214Dates.Date
FROM Docs214Dates
INNER JOIN (Docs214Picks INNER JOIN Docs214 ON Docs214Picks.DocID =
Docs214.UniID) ON Docs214Dates.DocID = Docs214Picks.UniID
WHERE Docs214Dates.Type = 1 AND
George Perolli wrote:
I used the Query Designer in Access to create the following query:
SELECT Docs214.BOL, Docs214Dates.Date
FROM Docs214Dates
INNER JOIN (Docs214Picks INNER JOIN Docs214 ON Docs214Picks.DocID =
Docs214.UniID) ON Docs214Dates.DocID = Docs214Picks.UniID
WHERE