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

William Hindman wdhindman at bellsouth.net
Tue Nov 4 16:54:59 CST 2003


..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
>




More information about the AccessD mailing list