I am having problems with getting an MSFlexigrid to show data from multiple tables at once.

i am sure that the sql is to blame

i need to reference firstname and lastname from a different table if the customer number matches with the account number

SELECT ACNumber, OpenBalance, TransType, TransAmt, ClosingBalance, Date, FirstName, LastName From LoanAcHistory, Customer WHERE ((LoanAcHistory.CustomerNumber = LoanAccount.CustomerNumber) AND ('" & iAccSearch & "' = LoanAccount.ACNumber))
ORDER BY Customer.LastName"