You can format the properties for your query’s fields in Design View so that their data appears in the format you specify. For example, you can specify where Access display the thousands operator in the Number field, format date fields to display different date formats, or format a text field to only display upper case letters.