Running total from query

[Guest]

Hi,

I'm building a database which will be used to monitor expenditure over
several site.
I'm having trouble finding a way to create a running total for each site. I
have one query which asks for user input to select a site, criteria = [Please
enter site Name]. This query works fine and displays all site matching the
criteria but i want to be able to display a running total of expenditure for
each site. Does anyone have any suggestions of how i can do this?

Hope this makes sense

Thank You

Dave

 

[Jeff Boyce]

Dave

This is something quite simple if you use a report based on your query. Add
a textbox to the report, set the Running Sum property.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Thank You Jeff,

Is it possible to get the same output on a form?

Dave

Dave

This is something quite simple if you use a report based on your query. Add
a textbox to the report, set the Running Sum property.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Hi,

I'm building a database which will be used to monitor expenditure over
several site.
I'm having trouble finding a way to create a running total for each site. I
have one query which asks for user input to select a site, criteria = [Please
enter site Name]. This query works fine and displays all site matching the
criteria but i want to be able to display a running total of expenditure for
each site. Does anyone have any suggestions of how i can do this?

Hope this makes sense

Thank You

Dave

 

[Guest]

Since we don't know much about your tables and fields, open Northwind and
create a new query based on the Orders table. To get a running sum of Freight
by Customer, use this SQL:
SELECT Orders.CustomerID, Orders.OrderDate, Orders.Freight,
(SELECT Sum(Freight)
FROM Orders O
WHERE O.CustomerID = Orders.CustomerID and O.OrderDate<=Orders.OrderDate)
AS RunSumFreight
FROM Orders
ORDER BY Orders.CustomerID, Orders.OrderDate;

--
Duane Hookom
Microsoft Access MVP

Thank You Jeff,

Is it possible to get the same output on a form?

Dave

Dave

This is something quite simple if you use a report based on your query. Add
a textbox to the report, set the Running Sum property.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

Hi,

I'm building a database which will be used to monitor expenditure over
several site.
I'm having trouble finding a way to create a running total for each site. I
have one query which asks for user input to select a site, criteria = [Please
enter site Name]. This query works fine and displays all site matching the
criteria but i want to be able to display a running total of expenditure for
each site. Does anyone have any suggestions of how i can do this?

Hope this makes sense

Thank You

Dave