Access Type For Result Values Query Designer. On the Home tab of the Ribbon click the View command. In addition to modifying your query criteria and joins after you build your queries you can choose to sort and hide fields in your query results.
Access displays the results of the query similar to figure. When you open an existing query in Access it is displayed in Datasheet view meaning you will see your query results in a table. The meaning is the same meaning for mathematic operator.
To modify your query you must enter Design view the view you used when creating it.
Business Explorer Functions in a Query Designer On the left side of the home screen of the Query Designer you have the InfoProvider pane it has the name of the Infocube and the list of all the characteristics and key figures available under that Infocube. Access displays the results of the query similar to figure. Example of using a Criteria in Query 1. Select query SQL query crosstab query param.