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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter by Month 1

Status
Not open for further replies.
herd

herd

Technical User
Joined
Jun 23, 2003
Messages
46
Location
US
What expression can I used to show only current month in a querry automatically?


Gary
 
Sort by date Sort by votes
[tt]...where month(yourdate) = month(date())[/tt] perhaps?

- but this is the Access Modules/VBA forum, shouldn't you rather ask such questions in the Queries and SQL forum (forum701?)

Roy-Vidar
 
Upvote 0 Downvote
How about?

WHERE Month([Date]) = Month(Now())



-Pete
 
Upvote 0 Downvote
I think roy deserves one too since he posted at the same time as me, and apparently seconds before.



-Pete
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question Question
Filter vba problem
Replies
1
Views
936
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question Question
Vba filter not working
Replies
7
Views
741
Cole Mendoza
Cole Mendoza
Moss100
  • Locked
  • Question Question
Open filtered for and set cursor at particular record
Replies
1
Views
824
Moss100
Moss100
AJAY0618
  • Locked
  • Question Question
How to pass a variable in VBA code by opening a form and storing the variable
Replies
3
Views
560
AJAY0618
AJAY0618
Moss100
  • Locked
  • Question Question
Hiding or resizing Access Application so my pop up form is all that is seen by the user
Replies
2
Views
460
jedraw
jedraw

Part and Inventory Search

Sponsor

Back
Top