MySQL Forums
Forum List  »  Microsoft Access

Running Totals in Query
Posted by: Waleed Ahmed
Date: February 06, 2005 03:55PM

I have Fields Of Travel Agent Name . And Check in Date and Check Out Date
and Total Rooms For Each Travel Agent .. Single and Double and Tripl ..

So i would like to Creat Running Total

Which Will tell me
1.Jan Travel Agent X Total Rooms in House 2 Total 2
2.Jan Travel Agent X Total Rooms in House 2 Total 4
3.Jan Travel Agent X Total Rooms in House 3 Total 7

but when i run this
Expr2: DSum("[Guest]![SGL]+[Guest]![DBL]+[Guest]![TRPL]+[Guest]![QTRPL]","Guest","DatePart('m', [C/IN])<=" & [AMonth] & " And DatePart('d', [C/IN])<=" & [ADay] & "")

It is working Good until date 31.Jan
and Query Start from 01.Feb Count From Beginning
While there is record For Travel Agent X .. Check in Date 31.Jan and Check Out 10.Feb
So what i have to Do to make it Count Totals with out Stop and Start from Beginning Each Month !!!
And to Not Calculate the Rooms Checked Out .. (( Date Of Today < Check Out Date ))
So Would you Please Help me to Fix this Query ??

Options: ReplyQuote


Subject
Views
Written By
Posted
Running Totals in Query
5741
February 06, 2005 03:55PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.