Microsoft Office Tutorials and References
In Depth Information
To Use a Number in a Criterion
To enter a number in a criterion, type the number without any dollar signs or commas. The following steps
display all clients whose current due amount is $0.00.
• Hide the Navigation pane.
• Click Create on the Ribbon to
display the Create tab.
• Click the Query Design button to
create a new query.
• With the Client table selected,
click the Add button in the Show
Table dialog box to add the Client
table to the query.
• Click the Close button in the Show
Table dialog box to remove the
dialog box from the screen.
• Drag the lower edge of the ﬁ eld
box down far enough so all ﬁ elds
in the Client table are displayed.
• Include the Client Number, Client
Name, Amount Paid, and Current
Due ﬁ elds in the query.
• Type 0 as the criterion for the
Current Due ﬁ eld (Figure 2–26).
Do I need to enter a dollar sign
and decimal point?
No. Access will interpret 0 as $0.00,
because the data type for the Current Due ﬁ eld is currency.
Current Due ﬁ eld
• View the query results
Why did Access display the results
as $0.00 when I only entered 0?
Access uses the format for the
ﬁ eld to determine how to display
the result. In this case the format
indicated that Access should
include the dollar sign and
only clients whose
Current Due amount
is $0.00 are included