Query Parameter - Retrieve Month & Year Only?

Posted on 2003-03-31
Medium Priority
Last Modified: 2012-06-21
I would like to create a query parameter that queries a date field in a query. The date is stored as  ’27-Mar-03’ .   I would like to be able to enter just the  Month and Year ( Mar-03 ) to retrieve all rows of data that have the Month and Year regardless of the day?  How do I code the criteria field of the Date? ... ... ... Thanks
Question by:moongamb
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 17

Accepted Solution

Natchiket earned 120 total points
ID: 8239238
One solution:

Between CDate("1/" & [ParaDate]) And DateAdd("m",1,CDate("1/" & [ParaDate]))-1

Author Comment

ID: 8239346
Natchiket  - Worked like a charm .... Thank ya much!

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question