I have three tables, Members, Events and EventDetails where I want to get the data from EventDetails for A record. Using this INNER JOIN but get a BOF/EOF error:
lngID = the MemberID of record needed.
Only variation that seems to work is Select * From table.
Any ideas would be helpful.
lngID = the MemberID of record needed.
Code:
sSql = "SELECT EventDetails.EventQty, EventDetails.EventAttend, EventDetails.EventAmount," & _
" Members.MemberID, Events.EventName" & _
" FROM Members INNER JOIN (Events INNER JOIN EventDetails ON Events.EventID = EventDetails.EventID)" & _
" ON (Members.MemberID = EventDetails.MemberID) AND (Members.MemberID = EventDetails.MemberID)" & _
" WHERE Members.MemberID=" & lngID
Only variation that seems to work is Select * From table.
Any ideas would be helpful.