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 wOOdy-Soft 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
Jun 23, 2003
46
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
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
Filter vba problem
Replies
1
Views
696
Andrzejek
Andrzejek
Moss100
  • Locked
  • Question
Vba filter not working 3
Replies
7
Views
509
Cole Mendoza
Cole Mendoza
Moss100
  • Locked
  • Question
Open filtered for and set cursor at particular record
Replies
1
Views
613
Moss100
Moss100
AJAY0618
  • Locked
  • Question
How to pass a variable in VBA code by opening a form and storing the variable
Replies
3
Views
399
AJAY0618
AJAY0618
Moss100
  • Locked
  • Question
Hiding or resizing Access Application so my pop up form is all that is seen by the user
Replies
2
Views
342
jedraw
jedraw

Part and Inventory Search

Sponsor

Back
Top