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
|
|||
|
|||
Report showing current total, previous total and average total?
Hi,
I would like to be able to design a report that shows the total monthly figure, the prvious months total and an average months total. Is this possible? I have some experience with VBA, but can't get my head around what data I would actually need... Thanks, Richard |
#2
|
|||
|
|||
Report showing current total, previous total and average total?
Yes, this is possible. You haven't specified if you want to also show
details or if you are grouping. It would help if you provided some sample records as well as desired output. -- Duane Hookom MS Access MVP -- "Richard Black" wrote in message ... Hi, I would like to be able to design a report that shows the total monthly figure, the prvious months total and an average months total. Is this possible? I have some experience with VBA, but can't get my head around what data I would actually need... Thanks, Richard |
#3
|
|||
|
|||
Report showing current total, previous total and average total?
Hi,
My desired data is basically a count of occurences of things in different locations. The table would look like: [date], [thing], [place] and the outputted data: [group by place] [group by thing] [thing], [count of thing for this month], [count of thing for previous month], [average monthly count of thing for previous 12 months] I have made a start by producing a query that finds all the [things] for a given month and year (taken from a combo box) and am working on another to find the [things] for the previous month. I then intend to produce a third query that will bring together both sets of data - is this a sensible way forward? Thanks, Richard "Duane Hookom" wrote in message ... Yes, this is possible. You haven't specified if you want to also show details or if you are grouping. It would help if you provided some sample records as well as desired output. -- Duane Hookom MS Access MVP -- "Richard Black" wrote in message ... Hi, I would like to be able to design a report that shows the total monthly figure, the prvious months total and an average months total. Is this possible? I have some experience with VBA, but can't get my head around what data I would actually need... Thanks, Richard |
#4
|
|||
|
|||
Report showing current total, previous total and average total?
I would create a query that Groups By Place and Thing and uses expressions
to calculate counts. PrevMthCount: Sum( Abs( Format(Date(),"yyyymm") = Format(DateAdd("m",1, [Date]),"yyyymm"))) You could create other columns using similar expressions that Sum the absolute value of a true or false expression. -- Duane Hookom MS Access MVP "Richard Black" wrote in message ... Hi, My desired data is basically a count of occurences of things in different locations. The table would look like: [date], [thing], [place] and the outputted data: [group by place] [group by thing] [thing], [count of thing for this month], [count of thing for previous month], [average monthly count of thing for previous 12 months] I have made a start by producing a query that finds all the [things] for a given month and year (taken from a combo box) and am working on another to find the [things] for the previous month. I then intend to produce a third query that will bring together both sets of data - is this a sensible way forward? Thanks, Richard "Duane Hookom" wrote in message ... Yes, this is possible. You haven't specified if you want to also show details or if you are grouping. It would help if you provided some sample records as well as desired output. -- Duane Hookom MS Access MVP -- "Richard Black" wrote in message ... Hi, I would like to be able to design a report that shows the total monthly figure, the prvious months total and an average months total. Is this possible? I have some experience with VBA, but can't get my head around what data I would actually need... Thanks, Richard |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Monthly Average Previous 12 Months | rjm65 | Worksheet Functions | 2 | July 16th, 2004 12:06 AM |