Creating Monthly Reports

[RIDEMNSLIDEM via AccessMonster.com]

I am using a query to update my report. So the problem is: I have data
stored by week ending dates (ie. 09/07/08, 09/28/08, 10/05/08). In my query
I am grouping by "WEDate". I now want to run my query for September and get
my 4 entries. I used DATE: [MonthName]. When I ran the query it asked me
for the month name, so I entered SEPTEMBER (Everything is working correctly
so far). Ran the query and low and behold October week end entry showed up.
Any ideas how to correct this? I also want to be able to run the query in
December and be able to ask for July information, the path that I am on seem
to only allow the Current month print out. Please help....

 

[John W. Vinson]

I am using a query to update my report. So the problem is: I have data
stored by week ending dates (ie. 09/07/08, 09/28/08, 10/05/08). In my query
I am grouping by "WEDate". I now want to run my query for September and get
my 4 entries. I used DATE: [MonthName]. When I ran the query it asked me
for the month name, so I entered SEPTEMBER (Everything is working correctly
so far). Ran the query and low and behold October week end entry showed up.
Any ideas how to correct this? I also want to be able to run the query in
December and be able to ask for July information, the path that I am on seem
to only allow the Current month print out. Please help....

Correct the error in your query criteria. If you would like help doing so,
please open the query in SQL view and post the SQL text; we can't see it from
here.

 

[RIDEMNSLIDEM via AccessMonster.com]

Sorry John,

I have been tinkering while I waited...
So now I can pull the correct monthly data that I need. YEAH!!, but it is in
numerical format. I would prefer to type in the month and year (ie.
SEPTEMBER 2008). Any suggestions?

Month: DatePart("m",[Week Ending]) & "/" & DatePart("yyyy",[Week Ending])
Criteria: [Enter Month and Year]

I am using a query to update my report. So the problem is: I have data
stored by week ending dates (ie. 09/07/08, 09/28/08, 10/05/08). In my query

[quoted text clipped - 5 lines]

December and be able to ask for July information, the path that I am on seem
to only allow the Current month print out. Please help....

Correct the error in your query criteria. If you would like help doing so,
please open the query in SQL view and post the SQL text; we can't see it from
here.

 

[RIDEMNSLIDEM via AccessMonster.com]

Disregard this thread - I figured out the problem
Solution:
=Format([datefieldsname],"Mmmm").
Thanks John

Sorry John,

I have been tinkering while I waited...
So now I can pull the correct monthly data that I need. YEAH!!, but it is in
numerical format. I would prefer to type in the month and year (ie.
SEPTEMBER 2008). Any suggestions?

Month: DatePart("m",[Week Ending]) & "/" & DatePart("yyyy",[Week Ending])
Criteria: [Enter Month and Year]
[quoted text clipped - 5 lines]

please open the query in SQL view and post the SQL text; we can't see it from
here.

 

[John W. Vinson]

Sorry John,

I have been tinkering while I waited...
So now I can pull the correct monthly data that I need. YEAH!!, but it is in
numerical format. I would prefer to type in the month and year (ie.
SEPTEMBER 2008). Any suggestions?

Month: DatePart("m",[Week Ending]) & "/" & DatePart("yyyy",[Week Ending])
Criteria: [Enter Month and Year]

If you really want your users to have to type a nine-letter month name with no
typos rather than a single keystroke...

use a calculated field like

TheMonth: Format([Week Ending], "mmmm yyyy")

and your same criterion. I wouldn't want to be one of your users though!!!!

I would suggest instead having a Form with a combo box based on a small table
with just one field - the first day of each month from now for the next twenty
years (you can use Excel... Fill Series to build this table in a couple of
minutes). Use a criterion such as

BETWEEN [Forms]![yourformname]![cboMonth] AND DateAdd("m", 1,
[Forms]![yourformname]![cboMonth])

You can format the date that the users pick any way you like and they'll be
able to just select it from the list rather than having to type it all out.