J
Josh Henry
My query in SQL looks like the following:
SELECT Sum(Journal.Amount) AS SumOfAmount,
Sum([Journal.Amount]+[Rent.Amount]) AS RentIncome
FROM Rent INNER JOIN Journal ON Rent.Tenant = Journal.Name
WHERE (((Journal.Type)="4") AND ((Journal.LocationID)=1) AND ((Journal.Date)
Between [Enter YTD beginning date] And [Enter ending date]));
As of now it makes sure it pulls the [Amount] field out of table [Journal]
only if [LOCID] = 1. I want to add the same qualifier for the [Amount] it
pulls from the table [Rent].
Any help would be greatly appreciated so I can apply the same principles to
other queries. Thanks
SELECT Sum(Journal.Amount) AS SumOfAmount,
Sum([Journal.Amount]+[Rent.Amount]) AS RentIncome
FROM Rent INNER JOIN Journal ON Rent.Tenant = Journal.Name
WHERE (((Journal.Type)="4") AND ((Journal.LocationID)=1) AND ((Journal.Date)
Between [Enter YTD beginning date] And [Enter ending date]));
As of now it makes sure it pulls the [Amount] field out of table [Journal]
only if [LOCID] = 1. I want to add the same qualifier for the [Amount] it
pulls from the table [Rent].
Any help would be greatly appreciated so I can apply the same principles to
other queries. Thanks