Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Birthdate query by month only

Status
Not open for further replies.
PlsHlpKat

PlsHlpKat

IS-IT--Management
Feb 20, 2003
49
US
How can I do a query by Birth month only using the birth date field? i.e. I need a report for all birthdays in January regardless of year.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
12 Month Rolling Average 2
Replies
15
Views
399
Swi
Swi
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
487
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
394
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
364
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
278
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top