Date Range in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a date/time format field. The dates range from years 1975
- 2005. I want to run a query that will select records with a date range for
just the first six months of each year. Is there a way to write a query for
this? for example:

between #01/01/1975# and #06/30/1975# or #01/01/1976# and #06/30/1976# etc...

this way I would have to do 30 "OR" statements. Since that cannot be done, I
would have to break it out and run multiple queries using a parameter input
box. I would rather do just on query.

Thanks for you help.

Marianne
 

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

Convert text to date 4
Access Running Balance in Access 1
Return a date range based on today's date 6
Multiple Criteria's 1
Date Parameter - Desperate for HELP!!!!!!!! 4
Anonomise data 4
Looking up across date ranges in Access 2
Between dates in a text field 6

Back
Top