DSUM a calculated field within a query

[hehrerh]

Name: accessquestion1.png  Views: 13  Size: 206.9 KB  ID: 29802" class="thumbnail" style="float:CONFIG" />

Hello,

I have a calculated field within a query. I want to create a column that displays the total original estimate value for that budget line item's accounting category.

I need to use a calculated field within a query to get to the original estimate because this value includes figures from multiple tables. Were I referencing a value from a TABLE I understand I could use the DSUM function. Is there a function similar to DSUM that can reference only localized fields from within a query?

Thanks,
Howie

[aytee111]

I don't use these in queries, they slow the queries down and make things more complicated. Rather crate a second query, with totals by key field, and bring that in to this query.

[kd2017]

How about a subquery like
SELECT [some key], SUM([OriginalEstimate)] AS SubtotalOriginalEstimate FROM [your table] GROUP BY [some key];
Then join the results of that to your query on [some key]?

[June7]

The aggregate query and joining to data is probably easiest and fast performer.

Then can build a report with that query and use its Sorting and Grouping features and summary calcs in group and report header/footer sections.

Can also use domain aggregate function in textbox.