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!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
QUERY THAT LOOKS FOR PRESENT YEAR VALUE
BTW, Thank you PHV, that worked perfect.- goober84
- Post #6
- Forum: Microsoft: Access Forms
-
QUERY THAT LOOKS FOR PRESENT YEAR VALUE
Thank you both very much. I am rather familiar with doing it your way kjv,but i was looking for it to not be in a static manner, or even a user input field where i had them enter the year, i was looking for it to always just look at the present year, but i really thank both of you for a very...- goober84
- Post #5
- Forum: Microsoft: Access Forms
-
QUERY THAT LOOKS FOR PRESENT YEAR VALUE
I have searched the forums and couldnt find this and i am sorry if this has already been posted. I have a query, that looks at a table. The table has a date field, in the format of mm/dd/yyyy. I want the query to only find records that equal the present year, i.e. this year it will only...- goober84
- Thread
- Replies: 6
- Forum: Microsoft: Access Forms
