Help!!! sum query

L

Liat

Hi,

In general, I have estimations for 5 subjects and I need to sum the last
estimation of each suit.

I have a main suits table and another table of estimations that has the
suitID that is connected to the ID of the suits table. One of the fields in
the main table is group.

In the estimations table I have the following fields: subject (5 optional
subjects), amount and date.

I created a query that contains 3 fields: subject (group by), suitID (group
by) and maxOfDate (Max) - of the date field.
This query works good - for each suit, I have the last estimation for each
subject.

I need to have the sum of the estimations (for each subject) for each group
(for the report).
I tried to create the following queris:
*The 2 tables are linked by suitID and the fields are subject (group by),
group(group by) and maxOfDate (Max) - of the date field.
*Using that query, and the other 2 tables, I created sum. I don't know what
to do......

Hope I explained well, if not, please ask me again, I really need the help,
Thanks a lot,
Liat
 
Top