View Single Post
  #1  
Old February 16th, 2007, 04:51 PM posted to microsoft.public.access.queries
Sue R via AccessMonster.com
external usenet poster
 
Posts: 12
Default date field by month in query but want only one year

I have a query that reads the date field by month and shows the results by
each month for every year. I want it to display only the results from one
year, which is typed in when prompted. I have tried different criteria but
when I run it, I get no results at all so obviously I'm doing something wrong.


any suggestions?

Thank you!
Sue

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/200702/1