Microsoft Office Tutorials and References
In Depth Information
Six Kinds of Queries
New eld’s name
Fields used in the calculation
Figure 4-8:
A
calculation
query.
Query results
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
recognize them.
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
Search JabSto ::




Custom Search