I'm using and MS-Query from excel to build an income/expense spreadsheet from QB using QODBC.  This worked fine last month but now is painfully slow/unusable.  Here is the query:

SELECT BillPaymentCheck.TxnDate, BillExpenseLine.ExpenseLineAccountRefFullName, BillExpenseLine.Memo, BillPaymentCheckLine.RefNumber, -BillPaymentCheck.Amount, BillExpenseLine.ExpenseLineClassRefFullName
FROM BillExpenseLine BillExpenseLine, BillPaymentCheck BillPaymentCheck, BillPaymentCheckLine BillPaymentCheckLine
WHERE BillPaymentCheckLine.AppliedToTxnTxnID = BillExpenseLine.TxnID AND BillPaymentCheck.TxnNumber = BillPaymentCheckLine.TxnNumber AND ((BillPaymentCheckLine.BankAccountRefFullName Like 'citizens%'))

I updated my operating system with MS update since I used this last but don't know of any other changes.  Any idea what happened or how to fix?  Many thanks!

The first problem is in: AND ((BillPaymentCheckLine.BankAccountRefFullName Like 'citizens%')), this will cause a full table scan on each pass to find the BillPaymentCheckLine rows. This should hardcoded something like this: AND ((BillPaymentCheckLine.BankAccountRefFullName = 'citizens bank acount')) or if you need to use muliple accounts: 

AND ( BillPaymentCheckLine.BankAccountRefFullName = 'citizens one account'  
or  BillPaymentCheckLine.BankAccountRefFullName = 'citizens two account'  )

The second problem is that your filter is on BillPaymentCheckLine, so it really should by the (first) primary table called in the query, like this instead:

FROM BillPaymentCheckLine BillPaymentCheckLine, BillPaymentCheck BillPaymentCheck, BillExpenseLine BillExpenseLine

and then the last join should reversed from: AND BillPaymentCheck.TxnNumber = BillPaymentCheckLine.TxnNumber to AND BillPaymentCheckLine.TxnNumber = BillPaymentCheck.TxnNumber