Hi everybody,
I have a problem with my running totals field.
Check the database below (password is "xixo").
In the detailshow form, there are a field called "Em Débito".
This form groups the records table by [Casa] and by date.
What I need is to sum all the [ValoR] values in the records table where [Data] is a date before the date in the row, and field Casa is the same as the [Casa] field in the query.
Can somedy help me please?
The database: http://www.danielmartins.com/gestao.zip
I have a problem with my running totals field.
Check the database below (password is "xixo").
In the detailshow form, there are a field called "Em Débito".
This form groups the records table by [Casa] and by date.
What I need is to sum all the [ValoR] values in the records table where [Data] is a date before the date in the row, and field Casa is the same as the [Casa] field in the query.
Can somedy help me please?
The database: http://www.danielmartins.com/gestao.zip
