Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Crosstab Queries & Reports
242
Reports
In the Design tab of the ribbon, press the Group & Sort button.
This opens a new section beneath our report.
Press the Add a group button, and set it as follows.
Reports
Reports summarise the information from our database and present it to users.
For our report we'll create a basic query and name it qry_order_details.
Reports
We can also calculate totals on our fields.
Select the Item_Price field & then the Totals button. From the drop down that appears, choose Sum.
Then select the Report button in the Create tab with qry_order_details in the objects panel.
Reports
After we've setup our report as we wish, we need to format it.
Common formatting options include:
- The Logo & Colour - Change defaults in the Property Sheet.
- The Title & Field Headings - double click them to edit.
KnowItAllNinja.com
Crosstab Queries & Reports
Crosstab Queries Cont.
Change the type of query from Select to Crosstab in the Design tab of the ribbon.
This will change the rows in the query design table.
Crosstab Queries
http://www.knowitallninja.com
Crosstab Query Cont.
To create our crosstab query, we need to set which of these fields will be the column heading, row heading, and value.
We also need to set what type of function will be performed on the value field.
Set this up as below.
Crosstab queries perform a sum, average or aggregate function on our data and then groups the results both horizontally and vertically.
Open the Query Design tool, add all four tables, and then setup our query as follows.
Crosstab Query Cont.
We can optionally add a final field to total the columns.
Add a fourth column as shown below:
We can then run our query & see our results.