Here are a couple of methods for creating calculations in queries vertically.
Q:Gang Wei writes to ask whether it is possible to create calculations in queries not only horizontally (like Total Cost: [UnitPrice] * [Quantity]), but also vertically, pulling in data from multiple rows.
A:Yes, this can be done in two ways. One (the more complex method) is to use a crosstab query; see the Access Archon article in this issue of WAW for an example of this. The other way is to click the Summation button (the capital sigma) on the toolbar in a select query, which turns it into a Totals query. A new row (the Total row) appears for each column, just select the appropriate function (Sum, Max, Avg, etc.) to produce the calculations you want.
