QReports and SQL Question
Posted on 2004-08-13
Hi Experts, this should be an easy one.....
I have the following tables in an Access DB:
Account_ID (Join to Transactions Table)
Account_ID (Join to Accounts Table)
What I want to do is generate a quick report that shows the sum of Trans_Credit for each account depending on the type of Trans_Decription the user selects.
If the user types in 'Interest', I want a query that will look at the Transactions table and Sum the Trans_Credit for each account where the Trans_Description is like 'Interest'
Output should look like:
Account Name Description Total
Account1 Interest $50.00
Account2 Interest $12.67
Account3 Interest $79.20
I started it off like below but I think I am WAY off :o(
SELECT Accounts.Account_Name, Transactions.Trans_Description, Sum(Transactions.Trans_Credit)
FROM Accounts, Transactions
WHERE Accounts.Account_ID = Transactions.Account_ID
AND Trans_Description like '%Interest%';