Chart Numbers on a Continuous Form

[Frank123]

Hi, being a novice to Access, I'm not sure if this can be done. Our company transports various items each month. I have an Access report that is set up to group by month. There is a text box on the report with an expression in the control source that sums up the shipping weights for each month, but the weights are not saved. My question; is there a way to create a chart that will show the summed weights for each month if the summed weights are not saved to a table? I'm using Access 2010. Any help would be greatly appreciated.

 

[Mark_]

You would want to create a query to SUM the total. For more help please click HERE

Effectively you would

SELECT SUM(ShipWeight) AS "Total ShipWeigth"
FROM Tbl_Shipping
WHERE Dt_Shipping BETWEEN Dt_BeginningOfMonth AND Dt_EndOfMonth

I'm using Dt_BeginningOfMonth and Dt_EndOfmonth because I'm not sure how your business rules deal with weekends that fall at the beginning/end of a month.

Hopefully this is useful for you!

 

[arnelgp]

What is the expression on the textbox, maybe you can use it as rowsource of the graph.

 

[Frank123]

Sorry for the delay, I was on vacation. Thanks for your replies. I used a combination of both your suggestions and it worked great. Thanks again.