gj88888

Hi, This doesn't seem to work. Maybe if I add some more detail it will help. So I have a table like this called TRANSACTIONS Date Payee Amount 01/01/2013 PTRP Ltd -1000.25 01/01/2013 HGJD Ltd -5986.56 02/01/2013 DUU AG 1000 05/01/2013 HH PLC -1000 I created a table called DATES that simple had all the dates of the year (I thought this might be the easiest way to do it, but maybe I do not need this table. Date 01/01/2013 02/01/2013 03/01/2013 04/01/2013 05/01/2013 06/01/2013 I want to create a query that would deliver this output. Date Balance 01/01/2013 -6986.81 02/01/2013 -5986.81 03/01/2013 -5986.81 04/01/2013 -5986.81 05/01/2013 -6986.81 06/01/2013 -6986.81 Thanks!

Hi, I need to have a running balance. This would not give a running balance right. So the output of the query should have a balance column. In this column would be the sum of all transactions on this date and previous dates. Even if there are no transactions in the table for a certain date, the query should display the balance.

Hi, could someone please help me with a SQL query. I have a table called TRANSACTIONS. In this table there are 3 fields Date, Payee & Amount. I am trying to create a query that will give the balance at every single day of the year. I have tried to do this with a table called DATES with dates in and link it, but I can not get this to work. Thanks in advance.