I am developing an Access applicatiion using Access 2003 with an MDB type file.
I have a SQL statement that is running inefficiently as follows:
inner join tblBanksReptNameCurr
On tblBanks.RptID=tblBanksReptNameCurr.[RPT ID]
set tblBanks.[SENIOR MANAGEMENT TAB] = tblBanksReptNameCurr.[SENIOR MANAGEMENT TAB] AND
tblBanks.CURRENCY = tblBanksReptNameCurr.CURRENCY
Is there a better way to create this SQL statement?