Demulling Family
demulling at centurytel.net
Tue Nov 4 20:13:21 CST 2003
Like I said it has been a long day. I am only pulling one fund. There can be many funds in the table that the query is being based on. I would like to do the running sum in the query. But to start off with I need it done in a form and then later on in a report. Stuart McLachlan wrote: >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 >> >> > > > >