Search results

Thanks for the warm welcome sir. I've tried subqueries a while ago and it turned out to be slower in performance also i indexed all the fields i use to search often. I was thinking my last resort is to denormalize to lessen table linking somehow.. But i am still on a hunt for may be a better...

An Access 2007 SQL recordsource for a query named qryTransactionList below is completely working but it is very slow. I am hopeful that there something that can be done here to make it more efficient and a little bit faster.. Any suggestions are welcome. Thanks in advance. SELECT...