Showing the last estimation in the report

  • Thread starter Thread starter Liat
  • Start date Start date
L

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
 
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
 
Back
Top