Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / December 2005

Tip: Looking for answers? Try searching our database.

Cummulative Query Function

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Craig - 06 Dec 2005 18:48 GMT
I am using Access XP.  I would like to create a query that returns a
cummulative number for a given person, then starts over with the next person.

for example.  Assume Expr1 returns the cummulative query function:

Name     Amt     Expr1
------     -----     ------
Smith      2          2
Smith      3          5
Smith      4          9        
Jones      1          1
Jones      3          4
Jones      2          6
Jones      1          7
.
.
.etc...

Thanks.
Signature

Craig

Duane Hookom - 06 Dec 2005 19:02 GMT
Marshall Barton just answered a similar question in the queries news group
less than two hours ago. Look for a subject of "Running Total"

Signature

Duane Hookom
MS Access MVP

>I am using Access XP.  I would like to create a query that returns a
> cummulative number for a given person, then starts over with the next
[quoted text clipped - 16 lines]
>
> Thanks.
Craig - 06 Dec 2005 19:17 GMT
Thanks.
Signature

Craig

> Marshall Barton just answered a similar question in the queries news group
> less than two hours ago. Look for a subject of "Running Total"
[quoted text clipped - 19 lines]
> >
> > Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.