M
Michalis J.
I have a table with account transactions and I want in a report to show the
transactions of a certain period and the balance amound of the account. At
the moment I am using a querry with no time constrains from which I get the
sums of all the transactions. I also create a querry from the table for the
period conserned and just add the first querry from which I get the sums of
the transactions. If I have any relationships between the table and the
querry I get no results. If I delete the relationship I get the results I
want.
I am new Access but I feel that this is not the best way to do this. Can
anybody suggest a better way?
transactions of a certain period and the balance amound of the account. At
the moment I am using a querry with no time constrains from which I get the
sums of all the transactions. I also create a querry from the table for the
period conserned and just add the first querry from which I get the sums of
the transactions. If I have any relationships between the table and the
querry I get no results. If I delete the relationship I get the results I
want.
I am new Access but I feel that this is not the best way to do this. Can
anybody suggest a better way?