Sort Data in Access Report

This Microsoft Access tutorial explains how to sort data in Access Report, including sort data in custom order. Sort Data in Access Report In Access Report Design View, you can sort data at the Group, Sort, and Total section, in this tutorial I will explain how to sort data in Detail and sort Grouped data. Example Suppose we have the below table that contains employee data. employee_tbl Employee ID Employee Name Department Team Salary 001 David HR Compensation 10000 ...
More

Create Matrix Report in Access Report

This Microsoft Access tutorial explains how to create Matrix report in Access Report using Crosstab Query and Expression. Access Matrix Report Matrix Report is like an Excel Pivot Table, where you can place fields in row and column, and then apply Aggregate Functions on a field value such as Count, Sum, Max. In newer version of Microsoft Access, Pivot Table function has been removed, you can only create Matrix Report through Crosstab Query, or write expression in Access Report. In this po...
More

Access VBA change Report Record Source

This Access tutorial explains how to change Access Report Record Source using VBA in order to modify Report criteria automatically. Change Report Record Source When you create an Access Report, you can specify the data source of the report in Report Record Source, which can be a Query or Table. Type the Table / Query name in the Record Source as below.   To add criteria to the Report, there are three ways Method 1 - Write SQL Type the full SQL statement directly in Record S...
More

Access Report group by date problem

This Access tutorial explains how to group by date (one date for each group) in Access Report and explain the issue. You may also want to read: Access Report keep a group together in one page Access Report group by date problem When you create an Access Report, the default setting isn't group by date. To illustrate, assume that we have an employee database as below. Table1 Hire Date Employee ID 20/12/2016 001 20/12/2016 002 21/12/2016 003 21/12/2016...
More

Access Report Hide Duplicates Property

This Access tutorial explains the Hide Duplicates property in Access Report. Access Report Hide Duplicates Access Field has a Property called "Hide Duplicates", which removes all consecutive duplicates in a column. Assume we have the following Report. Switch to Design View, click on Division text box in Detail section. In the Property Sheet, find the Hide Duplicates Property, set to Yes (default is No) Now switch to Print Preview, you will find Division duplicates are rem...
More

Access Report Section Property

This Access tutorial explains how to use Access Report Section Property to control Report Section such as Page Header, Footer. Access Report Section Property In Access Report VBA, you can directly access the Controls in the Report, it is also possible to access the Report Sections using Report Section Property, such as Page Header, Group Header, Page Footer, etc. This is especially useful to hide the whole Section. Syntax of Report Section Property Me.Section(Index) Index Constant D...
More

Access Report reset total page number and insert blank page

This Access tutorial explains how to reset page number and reset total page number for each group in Access Report. You may also want to read: Access Report page break by Group and add blank page Access Report Section Property Access Report reset page number and reset total page number When you have a Report that has different grouping, you may want to print out as separate reports with page number reset. In the previous post, I have demonstrated how to print out separate reports f...
More

Access Report page break by Group and add blank page

This Access tutorial explains how to add page break by Group in Access Report and add blank page if last page is odd number. You may also want to read: Access Report reset total page number Access Report page break by Group When we create Access Report which has different grouping, we may want to start a new page for each group. Assume that we have the following Report grouped by Department and Section. How do we start a new page for each Department? First, go to the Design Vie...
More

Access convert Table Query Report Form to Report Form

This Access tutorial explains how to convert from one Object to another, such as Query to Form/Report, convert Form to Report. Access convert Table, Query, Report, Form to Report or Form There are several kinds of conversion you can do among Access Objects. For example, convert a Form to Report, convert a Query to Form, etc. Suppose you have created a Query and you want use to print it out as Report, it would be a pain to move everything to the Report. Instead, you can simply do an automati...
More

Access error Type Num Div/0 Num

This tutorial explains the cause of Access errors in Access Query, Report, Form. These include #Error #Type! #Num! #Div/0! #Name. Access error #Error #Type! #Num! #Div/0! #Name There are several very common errors you may encounter in Access Query, Report or Form. It is very useful to understand the error in order to fix it, otherwise you will need to spend a lot of time to find out what Access is trying to tell you. Access error #Error! Access error #Error! occurs in an Expression where you...
More