Help - two data points in one month - access is summing them

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some monitoring results which should be carried out monthly. However
on occasions a measurement is made at the beginning of the month and right at
the end of the month (ie measurement is early for preceeding month). The
problem is when I produce a chart access sums the results for at month rather
than showing two points on the graph.

How can I get round this

Thank you
 
I have some monitoring results which should be carried out monthly. However
on occasions a measurement is made at the beginning of the month and right at
the end of the month (ie measurement is early for preceeding month). The
problem is when I produce a chart access sums the results for at month rather
than showing two points on the graph.

How can I get round this
Click to expand...

ummmm... by not summing for the month?

What's the Query you're using as the source for the chart?


John W. Vinson[MVP]
 
Back
Top