By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,294 Members | 2,588 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,294 IT Pros & Developers. It's quick & easy.

select records only in certain months

P: n/a
What is the best way to setup a query to select records in specific
months only. For instance if I want to compare sales in the month of
May regardless of year.

TIA

May 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SELECT Your_Table.*
FROM Your_Table
WHERE (((Month([Date_Field]))=5));
"francophone77" <fr***********@hotmail.com> wrote in message
news:11*********************@y43g2000cwc.googlegro ups.com...
What is the best way to setup a query to select records in specific
months only. For instance if I want to compare sales in the month of
May regardless of year.

TIA
May 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.