Querying a month range...

  • Thread starter Thread starter KK
  • Start date Start date
K

KK

I want to pull up records for dates between January and March. How do I
do that? I don't want the year, just by months. Thanks in advance.
 
Create a column in your query like

Field: TheMonth: Month([YourDateField])
Criteria: Between 1 And 3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Previous Month Query 5
Excel Vba to change displayed year automatically. 14
Calculate difference in rows in a query 1
Previous Month in query 1
Query that picks different column from a table based on the inp va 3
How to ignore the Year in a Date - Query 5
Filtering query by month and year 6
Filtering data by date range (but excluding YEAR) 2

Back
Top