asked on

How do I get all the dates that occured in a specifed month regardless of day or year?

We want to pay our respects to horses that have died in a specific month. So in my report, Horses that have Crossed Rainbow Bridge (died), I only want the names of the horses that died during the month of, say, August, regardless of day or year.
So what is the criteria in the datDateCrossedRainbowBridge column of the report's Record Source query?

SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Hamed Nasr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

aikimark

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Robert Batchelor

ASKER

For Dale Fye and hnsar: Your SQL works, thanks.

For aikimark: When I execute the report with Record Source of: SELECT * FROM tblHorses WHERE Month([datDateCrossedRainbowBridge]) = Month(Date)

I get a dialog box asking me ("Enter Parameter Value") for the "Date". If I enter todays date or any date the report works. I would like to be able to skip entering the date. How can I do this?

ASKER CERTIFIED SOLUTION

aikimark

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Robert Batchelor

ASKER

That worked. Access turns it into:
SELECT * FROM tblHorses
WHERE (((Month([datDateCrossedRainbowBridge]))=Month(Date())));

Thanks to all.

This report reminds us that in 2008 Point To Ponder was euthanized after screws securing the broken bone in her knee failed.
The tribute video is here: https://www.youtube.com/watch?v=hnQAlC7-vng

Robert Batchelor

ASKER

Many thanks to everyone that helps us with the horses. https://www.facebook.com/bhfer