I am developing and Access 2003 application using an MDB type file
How would you join another table named tblBanksRev to the follwing query as follows?
SELECT tblBanks.*, tblDates.dtRec, tblOpenItems.*
tblBanks INNER JOIN tblOpenItems ON tblBanks.[Bank Code]=tblOpenItems.Bank
WHERE tblOpenItems.t In ("A","D","E");
ADD the following table to the Query:
tblBanksRev.[BRS #] = tblBanks.[Bank Code]