Modify the Output Mode of a Select Query

Steps

For the Select query for which you want to modify the output mode, access the Design workspace.
In the grid in the Conditions section, depending on which mode you want to use, select or clear the Formatted check box as needed.
In the content header, select .

The query is run in the selected mode, and the results appear.

Note: When you run a query in unformatted mode, the results will still display formatted date values. Date values will always be displayed in the local time for the user.

Tip: You can save the query to save the selected mode. The next time you run the query, it will use the mode that was selected when it was last saved.