I am having a block. I have a field in my query which is a date field.
I have formatted the field so that it returns mm/yyyy.
I want to setup the criteria of the field so that it always shows me
only the last 12 months.
I have <=Month(Date())-14 as the criteria now, and that does show me the
January through December 2005 records, but I don't understand why I have
to have a -14? It seems more logical to have a -13 so that I can use
last month as the ending range.
Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
