Sum query on Organizations

[Amber]

Hi,

I have evaluations for each organizations.
The last estimation counts - so the estimation with the
closest date is the updates estimation of the
organization.
In each organizations there is more than one subject - ie
more then one record.

For that I created a query and put MAX on the date field.
This query is by ID - for each subject I see the updates
estimation.

Now, I would like to sum all of the updated estimations
for all of the subjects in each organization.

I tried to do that for a long time without any success.

Please if someone knows how it can be done, It will
really save me...

Thanks in advance,
Amber

 

[Jeff Boyce]

Amber

It would help me offer more relevant suggestions if you provided a bit more
information about the data structure.

On a hunch, have you looked into "Totals" queries?

 

[Amber]

Dear Jeff,
I managed to find a way to create this query.
Thank you very much.
The resulted table contains :
organization, estimation and paragraphNum.

I tried to add this query as a sub report to my report,
using 'organization' field as the linking fields.

When I triesd to open the report, I got the following
error: 'This expression is typed incorrectly, or it is
too complex to be evaluated.........'

One more important thing to mention is that when I tried
to create the child-parent link, I got the following
message: 'You must add field playerID to your record
source if you want to use this link'.

The thing is that now I don't want to use the playerID,
but the organization field.

Do you have any idea why I have been asked to do that?

Thanks a lot,
Amber

 

[Jeff Boyce]

I'll repeat my request ... if you want me to offer better advice, give me a
better idea of your data structure.