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 Docs214
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 Docs214Picks.
