A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Creating a Monthly Report



 
 
Thread Tools Display Modes
  #1  
Old August 6th, 2004, 08:05 PM
SLA
external usenet poster
 
Posts: n/a
Default Creating a Monthly Report

I need to report data for each month from an Access database. I would like to
set up the report so that I do not have to change the query each month. I
would like the business user to run the report for a specified month without
having to deal with query or with me. I have set up a query using the
STARTDATETIME field ( (DatePart("m",[StatsModuleLaunch]![StartDateTime]))=7)
to find the appropriate records . Right now, I go and change the query and
then run the report based on that query. How do I set up a prompt to change
the report ? It would be easier for business user to be able to answer a
prompt on a report vs. trying to work with queries. Also How do I
"automatically" change the Report Header so that it displays the month ie.,
Monthly Report for June 2004?
  #2  
Old August 6th, 2004, 08:33 PM
external usenet poster
 
Posts: n/a
Default Creating a Monthly Report

Try this to prompt your users...
Where you show 7 in your example (for July, I presume),
substitute the prompt string [Enter month number desired]
This will not be year sensitive, so don't mix records
from different years.

In the report title area insert a text box for the
month space containing the expression =MONTH
(STARTDATETIME), and format the box as MMMM). This should
work provided all the records passed to the report are
from the same month (as they should be).

Hope this works for you.


-----Original Message-----
I need to report data for each month from an Access

database. I would like to
set up the report so that I do not have to change the

query each month. I
would like the business user to run the report for a

specified month without
having to deal with query or with me. I have set up a

query using the
STARTDATETIME field ( (DatePart("m",[StatsModuleLaunch]!

[StartDateTime]))=7)
to find the appropriate records . Right now, I go and

change the query and
then run the report based on that query. How do I set up

a prompt to change
the report ? It would be easier for business user to be

able to answer a
prompt on a report vs. trying to work with queries. Also

How do I
"automatically" change the Report Header so that it

displays the month ie.,
Monthly Report for June 2004?
.

  #3  
Old August 6th, 2004, 08:33 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default Creating a Monthly Report

I would use a form with a text box that allows the user to select the month.
You could default the text box to either the current month or past month.
Then your report's recordsource would have a criteria like:
Month([DateField]) = Forms!frmMonthSelect!txtMonth
This will vary depending on if your date field contains records for more
than one year.

--
Duane Hookom
MS Access MVP


"SLA" wrote in message
...
I need to report data for each month from an Access database. I would like

to
set up the report so that I do not have to change the query each month. I
would like the business user to run the report for a specified month

without
having to deal with query or with me. I have set up a query using the
STARTDATETIME field (

(DatePart("m",[StatsModuleLaunch]![StartDateTime]))=7)
to find the appropriate records . Right now, I go and change the query and
then run the report based on that query. How do I set up a prompt to

change
the report ? It would be easier for business user to be able to answer a
prompt on a report vs. trying to work with queries. Also How do I
"automatically" change the Report Header so that it displays the month

ie.,
Monthly Report for June 2004?



  #4  
Old August 6th, 2004, 08:44 PM
external usenet poster
 
Posts: n/a
Default Creating a Monthly Report

Sorry - I goofed a bit. For the text box in the title
area use =STARTMONTHDATE, not the MONTH() Expression.

-----Original Message-----
Try this to prompt your users...
Where you show 7 in your example (for July, I

presume),
substitute the prompt string [Enter month number desired]
This will not be year sensitive, so don't mix records
from different years.

In the report title area insert a text box for the
month space containing the expression =MONTH
(STARTDATETIME), and format the box as MMMM). This

should
work provided all the records passed to the report are
from the same month (as they should be).

Hope this works for you.


-----Original Message-----
I need to report data for each month from an Access

database. I would like to
set up the report so that I do not have to change the

query each month. I
would like the business user to run the report for a

specified month without
having to deal with query or with me. I have set up a

query using the
STARTDATETIME field ( (DatePart("m",[StatsModuleLaunch]!

[StartDateTime]))=7)
to find the appropriate records . Right now, I go and

change the query and
then run the report based on that query. How do I set up

a prompt to change
the report ? It would be easier for business user to be

able to answer a
prompt on a report vs. trying to work with queries. Also

How do I
"automatically" change the Report Header so that it

displays the month ie.,
Monthly Report for June 2004?
.

.

  #5  
Old April 6th, 2010, 03:33 PM posted to microsoft.public.access.gettingstarted
charkey
external usenet poster
 
Posts: 6
Default Creating a Monthly Report



"YL" wrote:

It was really really helpful~ Thank you.

"Duane Hookom" wrote:

I would use a form with a text box that allows the user to select the month.
You could default the text box to either the current month or past month.
Then your report's recordsource would have a criteria like:
Month([DateField]) = Forms!frmMonthSelect!txtMonth
This will vary depending on if your date field contains records for more
than one year.

--
Duane Hookom
MS Access MVP


"SLA" wrote in message
...
I need to report data for each month from an Access database. I would like

to
set up the report so that I do not have to change the query each month. I
would like the business user to run the report for a specified month

without
having to deal with query or with me. I have set up a query using the
STARTDATETIME field (

(DatePart("m",[StatsModuleLaunch]![StartDateTime]))=7)
to find the appropriate records . Right now, I go and change the query and
then run the report based on that query. How do I set up a prompt to

change
the report ? It would be easier for business user to be able to answer a
prompt on a report vs. trying to work with queries. Also How do I
"automatically" change the Report Header so that it displays the month

ie.,
Monthly Report for June 2004?




  #6  
Old April 6th, 2010, 03:41 PM posted to microsoft.public.access.gettingstarted
charkey
external usenet poster
 
Posts: 6
Default Creating a Monthly Report

I tried the suggestion below and do not know how to format the month to come
out as the writen name not the number. Question is the same as the original
stated where I have and input [Month] to run the monthly report and want to
put the month name in the title from the input.

Thanks,

Cecil

" wrote:

Try this to prompt your users...
Where you show 7 in your example (for July, I presume),
substitute the prompt string [Enter month number desired]
This will not be year sensitive, so don't mix records
from different years.

In the report title area insert a text box for the
month space containing the expression =MONTH
(STARTDATETIME), and format the box as MMMM). This should
work provided all the records passed to the report are
from the same month (as they should be).

Hope this works for you.


-----Original Message-----
I need to report data for each month from an Access

database. I would like to
set up the report so that I do not have to change the

query each month. I
would like the business user to run the report for a

specified month without
having to deal with query or with me. I have set up a

query using the
STARTDATETIME field ( (DatePart("m",[StatsModuleLaunch]!

[StartDateTime]))=7)
to find the appropriate records . Right now, I go and

change the query and
then run the report based on that query. How do I set up

a prompt to change
the report ? It would be easier for business user to be

able to answer a
prompt on a report vs. trying to work with queries. Also

How do I
"automatically" change the Report Header so that it

displays the month ie.,
Monthly Report for June 2004?
.


  #7  
Old April 6th, 2010, 04:22 PM posted to microsoft.public.access.gettingstarted
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Creating a Monthly Report

Format((STARTDATETIME, "mmmm") will give you January, February, March...

Format((STARTDATETIME, "mmm") will give you Jan, Feb, Mar...

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"charkey" wrote in message
...
I tried the suggestion below and do not know how to format the month to
come
out as the writen name not the number. Question is the same as the
original
stated where I have and input [Month] to run the monthly report and want
to
put the month name in the title from the input.

Thanks,

Cecil

" wrote:

Try this to prompt your users...
Where you show 7 in your example (for July, I presume),
substitute the prompt string [Enter month number desired]
This will not be year sensitive, so don't mix records
from different years.

In the report title area insert a text box for the
month space containing the expression =MONTH
(STARTDATETIME), and format the box as MMMM). This should
work provided all the records passed to the report are
from the same month (as they should be).

Hope this works for you.


-----Original Message-----
I need to report data for each month from an Access

database. I would like to
set up the report so that I do not have to change the

query each month. I
would like the business user to run the report for a

specified month without
having to deal with query or with me. I have set up a

query using the
STARTDATETIME field ( (DatePart("m",[StatsModuleLaunch]!

[StartDateTime]))=7)
to find the appropriate records . Right now, I go and

change the query and
then run the report based on that query. How do I set up

a prompt to change
the report ? It would be easier for business user to be

able to answer a
prompt on a report vs. trying to work with queries. Also

How do I
"automatically" change the Report Header so that it

displays the month ie.,
Monthly Report for June 2004?
.




  #8  
Old April 6th, 2010, 04:49 PM posted to microsoft.public.access.gettingstarted
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default Creating a Monthly Report

Oops. Typo. That should be

Format(STARTDATETIME, "mmmm") will give you January, February, March...

Format(STARTDATETIME, "mmm") will give you Jan, Feb, Mar...


--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"Douglas J. Steele" wrote in message
...
Format((STARTDATETIME, "mmmm") will give you January, February, March...

Format((STARTDATETIME, "mmm") will give you Jan, Feb, Mar...

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"charkey" wrote in message
...
I tried the suggestion below and do not know how to format the month to
come
out as the writen name not the number. Question is the same as the
original
stated where I have and input [Month] to run the monthly report and want
to
put the month name in the title from the input.

Thanks,

Cecil

" wrote:

Try this to prompt your users...
Where you show 7 in your example (for July, I presume),
substitute the prompt string [Enter month number desired]
This will not be year sensitive, so don't mix records
from different years.

In the report title area insert a text box for the
month space containing the expression =MONTH
(STARTDATETIME), and format the box as MMMM). This should
work provided all the records passed to the report are
from the same month (as they should be).

Hope this works for you.


-----Original Message-----
I need to report data for each month from an Access
database. I would like to
set up the report so that I do not have to change the
query each month. I
would like the business user to run the report for a
specified month without
having to deal with query or with me. I have set up a
query using the
STARTDATETIME field ( (DatePart("m",[StatsModuleLaunch]!
[StartDateTime]))=7)
to find the appropriate records . Right now, I go and
change the query and
then run the report based on that query. How do I set up
a prompt to change
the report ? It would be easier for business user to be
able to answer a
prompt on a report vs. trying to work with queries. Also
How do I
"automatically" change the Report Header so that it
displays the month ie.,
Monthly Report for June 2004?
.






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a report from a form Kristin Setting Up & Running Reports 7 June 28th, 2004 09:21 PM
Label SRIT General Discussion 2 June 22nd, 2004 09:42 PM
Problem Creating Report [email protected] Using Forms 1 June 7th, 2004 07:51 AM
Creating a Graph in a report... Setting Up & Running Reports 2 May 26th, 2004 05:21 PM
Creating a PivotTable Report from an Another PivotTable Report bcpaulus Worksheet Functions 1 January 8th, 2004 08:56 PM


All times are GMT +1. The time now is 09:17 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.