Hi there, I'm currently writing an accounting system and i got stuck with this section of trying to produce the account name in a query.
i have four tables
tblPurchase
PurchaseID -Number
tblAccounts
AccountID - Number
AccountName - Text, usually has names like asset, cost of sales...