Microsoft Office Tutorials and References
In Depth Information
Six Kinds of Queries
New eld’s name
Fields used in the calculation
3. After the colon, in square brackets (), enter the name of a field
whose data you use for the calculation.
In Figure 4-8, data from the Unit Price and Quantity fields are used in the
calculation, so their names appear in square brackets: [Unit Price] and
[Quantity]. Be sure to spell field names correctly so that Access can
4. Complete the calculation.
How you do this depends on what kind of calculation you’re making. In
Figure 4-8, I entered an asterisk (*) to multiply two fields together. The
equation multiplies the values in the Unit Price and Quantity fields. You
can add the data from two different fields — including calculated fields —
by putting their names in brackets and joining them with a plus sign, like
so: [SubTotal]+[Shipping Cost].
Sometimes the results of the query aren’t formatted correctly on the
datasheet. To assign a new format to a field you create for the purposes
of making a calculation query, right-click the field on the Query grid and
choose Properties. The Property Sheet appears. On the General tab, click