Showing the last estimation in the report

[Liat]

Hello,

I have a main table of suits and another table of
estimations. In the estimation table, I have paragraph
number and amount and of course the suitID - so it will
be related to the main table. I have 5 possible
paragraphs.

I have difficulties in doing the following thing:
I would like to have the last estimation for each
paragraph for a given date. For example, if I have 2
estimations to paragraph 1, I would like the most updated
one to appear in the report. If the given date
is "smaller" then the most updates then the less updated
one should appear. I have to do that for all of the
paragrahs (in the file I sent you, it had 4).


Any help will be a very big help for me, I really don't
know how to do that
Thanks a lot,
Liat

 

[Fons Ponsioen]

Create a summing query with the paragraph number and the
date, set the property of the date to max.
Now include this query in your main table.
Hope this helps.
Fons