Hi everyone, I would like to create a query that does a running total for each account, but I also want to show a 'phantom' row that gives the end of month with the last day of the month as the transaction date. Here's a sample query:
--- taken from http://bit.ly/speZzs Is there a way to have that 'phantom' row for each account? I want to result to be ordered by customer_id, account_type. More details: In my situation, I have Customers and Grain types. I want to generate a result that will show Customer, Grain Type, Daily Avg Bal, Charge Rate, discount, Charge. Maybe it's not really possible. I see it a bit hard group it properly, showing only single row per customer per grain. Many thanks, Mark |