Incorrect Totals in Query

R

Ros Orgel

I hope someone can help with this. If I use Totals in a query that is based on an underlying query that groups records I get the correct totals. If I try to use totals without grouping records first (which is what I'm trying to do), I get the wrong answer. Here's the SQL that works: SELECT Sum(FundingSourceBudgets.[Full Amount]) AS [SumOfFull Amount], Sum(FundingSourceBudgets.BudgetCategoryAmount) AS SumOfBudgetCategoryAmoun
FROM FundingSourceBudgets

Here's what doesn't work: SELECT Sum(FundingSourceBudget.BudgetCategoryAmount) AS SumOfBudgetCategoryAmoun
FROM FundingSourceBudget

Thanks for any help you can offer.
 
Top