Summing my Query

[Kavy]

Hello

I have created the below query using the query design tool in Access 2007

<code>
SELECT (Date()-[Start])*[$perDay] AS BTD, [Amount]/([end]-[start]) AS [$perDay], BAccounts.Amount, BAccounts.Open
FROM BVendors INNER JOIN BAccounts ON BVendors.ID = BAccounts.BVendor
WHERE (((BAccounts.Amount)<0) AND ((BAccounts.Open)=True));
</code>

When I try to sum the field BTD, I get an error saying "you tried to execute a query that does not include the specified expression <surname> as part of an aggregate function. (Error 3122)"

Anyone know the solution?

Thank you

Kavy

 

[james_lankford]

save that query then make a new query using that one as the source

then you can sum BTD

but if you put any other fields in the select in the 2nd query then you will have to put those same fields in a group by in the 2nd query

 

[Kavy]

save that query then make a new query using that one as the source

then you can sum BTD

but if you put any other fields in the select in the 2nd query then you will have to put those same fields in a group by in the 2nd query

Thank you!