Home   Fees/Services   Access Templates   Tutorials  Tutorial Downloads   Articles   Search   Contact  Privacy  Links
Access Report Filters
Query Filters for Reports
Home > Tutorials > Query Tutorials > Report Query Filters
 






Query Tutorials Index:
Too Complex Query
Aggregate Query
Not In Operator
Choose Function
Crosstab Query
Date Time Query
Delete Query
External Table Query
Report Filter Query
Group By Query
Having Query Clause
Histogram Query
Access Append Query
Master Detail Update
Order By Query
SQL Parameter Query
Predicate Query
Self Join Query
Scalar SubQuery
Master Detail Query
Select Query
Select Top
Union Query
SQL Update Query
Custom Query Function

 

MultiSelect Parameter Forms Query Tutorial


Access Report Filter Tutorial

Form Fields as Report Filters

Access Report Filter via a parameter form field.  In the report filtering example we use the Employee_ID selected in filter report example to query selected employee records for a report.



Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. Experts in small business management and scientific database programming.

Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.


 Many users and developers would use filters on the report to accomplish this task.

Report filters are ok to use however, putting these paramters in the SQL query for the report usually executes more quickly.  This example assumes that you have a combo box (named: Emp_Combo), as defined in a previous example, in a form called F_Emp.

Filter Report Records Using Form Field Parameter Example:

Select M_Employees.Name, M_Employees.Emp_Number, M_Employees.Address
From M_Employees
Where
Forms!F_Emp!Emp_Combo=0 or Forms!F_Emp!Emp_Combo = M_Employees.Employee_ID;

This SQL query will select a specific employee or All employees for the report filter based on the Emp_Combo in the parameter form (F_Emp).  Note: You could have several combo boxes on the parameter form which would allow the user to filter report records based on a combination of several fields.   This Access report filter method provides a very powerful reporting feature.  (Warning:  Access may attempt to re-write your 'where' clause making it non-functioning).

Warning: If you ever want to upsize this Microsoft Access database to SQL Server then you should not refer to form fields within the query.  SQL Server can't deal with these references. 

More MS Access Report Filter Query Examples:

Parameter Query  as Reports Filter







A Blue Claw Software Design Template:

Document Revision Control Application
 









A Blue Claw Database Design Article:

How To Create Faster Access Databases
 









Blue Claw Database Design Downloadable Tutorial:
How To Perform Inventory Calculations (Multi-User)  








Microsoft Office:
MS Access 2000 Through Access 2016 & Office 365
 


Contact Information

Copyright 2000-2017 Blue Claw Database Design