Graph - Daily usage

[Tkandy]

I would like to produce a graph which has a year to date usage and a trendline of what we should not exceed.

I know how to do graphs but i cannot seem to get the query to run correctly

We document at the moment a daily reading

[Date] [Well1] [Well 2]

In a query i have got the daily usage of both wells but i cannot figure out how to sum it

I am only new at this so any help would be great

 

[PNGBill]

To sum in a query there are at least two options.

You could use a 2nd query with just say well and date fields using the first query as its data source and then click the totals button and group by well field and sum by date.
This should give you a result for each well of the sum of all dates selected. Your earlier query would have criteria filtered the dates eg if you just wanted this months dates or all dates for the first 5 days of each month etc.
Experiment with the totals as you can have a sum and a count plus a few more.

The other option is to add a calculated field to the query.
If your query gave you fields for well, date1, date2 & date3 then you add another field to the query as: DateSum: ([date1]+[Date2]+[Date3])
This should ten result with Well, Date1, Date2, Date3 & DateSum being the query result.
Experiment with this also as you can use functions instead of just [field]+[Field] in the new query field and get Percentages, FullName: [firstname]&" "&[lastname], Change "31/12/2009" to "2009" as just the tip of the ice berg.

 

[Tkandy]

Thank you i will try to see if i can do these