[AccessD] Help with Query - Should be simple but my brian is fried

William,
You can read between the lines and handle the "by fund", the problem 
is getting a running sum in a *query* rather than a report.

Jeffrey, 
Do you really mean in a query, or will a report do it.



On 4 Nov 2003 at 17:54, William Hindman wrote:

> ..I'm confused ...you want it sorted by transaction date but you want a
> running total by fund ...but the FundNumber isn't an output field you can
> group on?
> 
> William Hindman
> Government is not reason, government is not persuasion,
> government is force. It is a dangerous servant." G. Washington
> 
> ----- Original Message ----- 
> From: <jeffrey.demulling at usbank.com>
> To: <accessd at databaseadvisors.com>
> Sent: Tuesday, November 04, 2003 4:59 PM
> Subject: [AccessD] Help with Query - Should be simple but my brian is fried
> 
> 
> >
> > First off forgive me for asking about this as I should remember how to do
> > this but it has been a long day today.
> >
> >
> >
> >
> >
> >  I have a table with the following fields (Field Type in Paras):
> >
> >
> >  TransactionNumber (Autonumber)
> >
> >
> >  FundNumber (LongInteger)
> >
> >
> >  TransactionDate (Date)
> >
> >
> >  TransactionAmount (Double)
> >
> >
> >  TransactionComments (Text:255)
> >
> >
> >  What I need to do is have an output similar to the following:
> >
> >
> >
> >
> >
> >  TransacationDate
> >
> >
> >  Transaction Amount
> >
> >
> >  Running Total for Fund
> >
> >
> >  This is sorted by Transaction Date
> >
> >
> >
> >
> >
> >  Thanks for your help.
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.