Sum query on Organizations

  • Thread starter Thread starter Amber
  • Start date Start date
A

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
 
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?
 
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
 
I'll repeat my request ... if you want me to offer better advice, give me a
better idea of your data structure.
 
Back
Top