--- description: In this article we look at using parameter query to limit records to a specific data range. title: How to Use the Parameter Query in MS Access Report to Limit Records to a Specific Date Range image: https://www.datanumen.com/blogs/wp-content/uploads/2017/10/using-the-parameter-query-in-a-report-to-limit-records.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Access Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/access-solutions/) > How to Use the Parameter Query in MS Access Report to Limit Records to a Specific Date Range # How to Use the Parameter Query in MS Access Report to Limit Records to a Specific Date Range [Access Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/access-solutions/) September 29, 2025 Share Now: - - - - - - - - *Using parameter query in MS Access is a child’s play; it is as easy as using a Criteria for creating a query. In this article we look at using them to limit records to a specific data range.* ![Using The Parameter Query In A Report To Limit Records](https://www.datanumen.com/blogs/wp-content/uploads/2017/10/using-the-parameter-query-in-a-report-to-limit-records-300x207.jpg "Using The Parameter Query In A Report To Limit Records")A parameter query is one of the most useful and easiest ways of creating an advanced query. It is one of the most common methods used for creating queries. One of the unique features about parameter query is that it allows users to create queries which can be updated, during the command to reflect on the new search term. When a user operates through parameter query, Access prompts them towards a search term, enlisting all possible query results that reflect their search. ## Uses of Parameter Query - Parameter Query in MS Access is used for restricting a set of records, which are reflected in the form query returns according to the user’s search. - Operating parameter query is as simple as creating a query, which uses criteria. A parameter query is used to prompt one piece of information to the user like a part number or for more such as two dates. - Parameter Query displays a separate dialog box parameter for each query, which prompts the value of that particular parameter or query search. ## Method: Parameter Query The easiest way to use parameter query is by directly basing the report on the field. This approach works usually with all types of queries; however, it does come with a few disadvantages: - Inflexible: Requires both dates to be entered. - Inferior Interface: Pop-up problems (two dialog boxes show up unexpected) - No alternative way for validation of dates - No way to transfer or supply defaults. ## How to Create Parameter Query? **Step 1:** Users can create a query by using any RecordSource from their report. **Step 2:** Now go to the query design view and enter the following example in Criteria row, right under your date field. \>= \[StartingDate] < \[EndingDate] + 1 **Step 3:** Now users can choose parameters enlisted on the Query menu. Now declare any two parameters as type Date/Time. StartingDate    Date/Time EndingDate      Date/Time **Step 3:** In order to display all the limiting dates in the report, users need to open their report in the Design View. Now they need to insert two text boxes in the report header section. Note user will also have to set the property setting of ControlSource onto “=StartingDate and =EndingDate”. ![Parameter Query]( "Parameter Query") Despite being one of the easiest ways to search for a query, it is often criticized for its lack of efficiency. Users find multiple dialog box design of parameter query insufficient and frustrating for all their purposes. However, users can solve this problem by creating a form which can meet their parameter collection needs. Despite being time-consuming and inflexible, parameter query still remains one of the most popular ways to search queries for record restricted data range. At times while working with a MS Access database you may encounter incidents of database corruption which can jeopardize your important data. To avoid a data loss scenario, regular Access users are advised to opt for a reliable tool to deal with [corrupted Access](https://www.datanumen.com/access-repair/) database in emergencies. ## Author Introduction: Vivian Stevens is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [mdf fix](https://www.datanumen.com/sql-recovery/) and excel recovery software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/quickly-print-files-zip-attachment-outlook-email/) [Next post →](https://www.datanumen.com/blogs/2-methods-auto-insert-signature-meeting-invitations-outlook/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"How to Use the Parameter Query in MS Access Report to Limit Records to a Specific Date Range","datePublished":"2017-10-12T05:19:49+00:00","dateModified":"2025-09-29T04:09:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/"},"wordCount":577,"commentCount":0,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/using-the-parameter-query-in-a-report-to-limit-records.jpg","articleSection":["Access Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/","url":"https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/","name":"How to Use the Parameter Query in MS Access Report to Limit Records to a Specific Date Range","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/using-the-parameter-query-in-a-report-to-limit-records.jpg","datePublished":"2017-10-12T05:19:49+00:00","dateModified":"2025-09-29T04:09:20+00:00","description":"In this article we look at using parameter query to limit records to a specific data range.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/how-to-use-the-parameter-query-in-ms-access-report-to-limit-records-to-a-specific-date-range\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/using-the-parameter-query-in-a-report-to-limit-records.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2017\/10\/using-the-parameter-query-in-a-report-to-limit-records.jpg","width":976,"height":674,"caption":"Using The Parameter Query In A Report To Limit Records"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```