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.