There're 2 tables:

- 'Years' contains 2 years (for example)

- 'Sum for Year' contains a fild with Numbers.

And a summary fild -- Total of all these Numbers.

And of course there's relation between these tables.

The task is:

to get Total (in 'Sum for Year') for the Found Set 'Year'=2005 (f.ex.) in 'Years'

I'm a novice & cannot find any information how to organize this operation.

Thanks.

test.zip

I think this is what you wanted.

test.zip

Thanks a lot, Breezer!

But the stucture was changed -- I think I didn't describe the problem sufficiently.

Years were: 2005, 2006, 200_5_

(These are invoices; invoice dates, not a list of years). Now that's a list of 3 years: 2005, 2006, 2007

The idea was: based on an invoice year/date (in 'Years' containing many invoices (Names, Origin, etc.), f.ex. 2005, to select/find operations in 'Sum for Year' for these invoices/year & to get a sum for this period.

Edited January 9, 200620 yr by Guest

Thanks, Breezer!

Based on your solution, I decided the problem.

My version is attached.

test.zip

Edited January 10, 200620 yr by Guest

Can we use this to calculate previous month's total and use it as balance bring forward for the next month ? How do we do it in this case?

Anyone can help me on this ?

Yes, but the Search1 field should contain complete dates that should be joined via less or equal operator in the relations def.

We should instead have a relational leg more in the fork, the keyfield definitions could be made like this...

1) previous month startdate:

Date ( Month ( Get ( CurrentDate ) ) -1; 1 ; Year ( Get ( CurrentDate ) ) )

2) previous month end date:

Date ( Month ( Get ( CurrentDate ) ) ; 0 ; Year ( Get ( CurrentDate ) ) )

--sd

Thanks SD for helping. But I still don't get the way you mentioned to implement it into my solution. What I need is shown in the file I attached.

balance.zip

Edited April 13, 200619 yr by Guest

Anyone can help me on this ? Thanks in advance. Sorry for the double post since I am desperately need solution for this matter.