Adding a calculated field to a query

[Bren Pierce]

How can I add a calculated field to a query ie. Order_Count: Order_Count

 

[Duane Hookom]

Order_Count seems to be a aggregation. These are enabled in your query design
by selecting View->Totals. This will aggregate your records and generally
require setting the Total: row in the query to something like Group By,
Count, Sum, or Avg.

If you want a new column created that performs calculation, you enter the
expression into a new blank column in the grid. Your expression might look
like:

Order_Count: {your expression here]

You might want to search the web for SQL QUERY SYNTAX.

 

[Bren Pierce]

Thanks Duane, I'll give it a try

Order_Count seems to be a aggregation. These are enabled in your query design
by selecting View->Totals. This will aggregate your records and generally
require setting the Total: row in the query to something like Group By,
Count, Sum, or Avg.

If you want a new column created that performs calculation, you enter the
expression into a new blank column in the grid. Your expression might look
like:

Order_Count: {your expression here]

You might want to search the web for SQL QUERY SYNTAX.
--
Duane Hookom
Microsoft Access MVP

How can I add a calculated field to a query ie. Order_Count: Order_Count