Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AndrewAfresh

    Problem referring to aggregates in query calculation

    Please can someone explain what I'm doing wrong with a query calculation. As shown on the attached screen print, I entered an expression of "[TotalRates]/[CountRefs]" which uses the names of the two aggregates in the overall footer. However it gives a "does not exist" error.
  2. AndrewAfresh

    How to add aggregates to group footer

    I'm trying to create my first grouped report. I'm grouping by a field called 'Position' and I can see the Position footer but how do I add aggregate fields to the footer? When I click a column, then click the aggregate button then Count, I get a new Overall row. Thank you!

Part and Inventory Search

Back
Top