H
hkgary33 via AccessMonster.com
Dear all, (my question is a bit long…sorry for that)
I’ve built a table called tblFileInfo, in each record, it consists of 11
fields, one field is for storing the file date, 5 numeric fields are storing
5 types of counts (Acount1 to Acount5), the remaining 5 numeric fields are
storing another 5 types of counts (Bcount1 to Bcount5).
And then I’ve built a query to show only those records with specific file
date period requested by the user.
Now I don’t know how to calculate the sum of counts and plot two charts, the
details are as follows:
Base on the result of this query to plot a chart (chart A) in which the month
is the x-axis, and the number of total “A counts” is the y-axis. For example,
if in the query, the range of the dates is exactly one year (12 months), then
totally 12 points will be plotted in the graph, and the y co-ordinate of each
point is determined by the total sums of the “A counts” within that
particular month’s record (i.e. the sum of the total “A counts” of each
record in that month). Similarly, for another chart (chart B), it uses the
total “B counts” to plot.
Or before plotting the charts, do I firstly need another query to calculate
the counts so as to simplify solving the problem?
Thanks so much!!!
Gary
I’ve built a table called tblFileInfo, in each record, it consists of 11
fields, one field is for storing the file date, 5 numeric fields are storing
5 types of counts (Acount1 to Acount5), the remaining 5 numeric fields are
storing another 5 types of counts (Bcount1 to Bcount5).
And then I’ve built a query to show only those records with specific file
date period requested by the user.
Now I don’t know how to calculate the sum of counts and plot two charts, the
details are as follows:
Base on the result of this query to plot a chart (chart A) in which the month
is the x-axis, and the number of total “A counts” is the y-axis. For example,
if in the query, the range of the dates is exactly one year (12 months), then
totally 12 points will be plotted in the graph, and the y co-ordinate of each
point is determined by the total sums of the “A counts” within that
particular month’s record (i.e. the sum of the total “A counts” of each
record in that month). Similarly, for another chart (chart B), it uses the
total “B counts” to plot.
Or before plotting the charts, do I firstly need another query to calculate
the counts so as to simplify solving the problem?
Thanks so much!!!
Gary