If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
date field by month in query but want only one year
On Fri, 16 Feb 2007 16:51:18 GMT, Sue R via AccessMonster.com wrote:
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 Add a new column to the query grid. ForYear:Format([DateField],"yyyy") As criteria on the column, write: [What year?) When prompted, enter a 4 digit year. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|