E
ET Sherman
Eric,
Try this:
1. On the query design grid I assume that you have already
linked the two tables by the Project Id field.
2. Add the Project ID field, Budget Amount field and the
Actual Amount field.
3. Click the Totals icon on the toolbar to display the
Total line in the query grid below the fields.
4. On the Total line for the Project ID set it to Group By.
Set the Budget Amount field Total line to First. Set the
Actual Amount field Total line to Sum.
This will accomplish what you are trying to do.
Note: You can change the field names in a query by typing
a new field name followed by :
Example, BUDGETAMT: YourFieldName
Instead of showing FirstOFBudgetAmount and
SumOfActualAmount.
Regards,
Eric T. Sherman
Try this:
1. On the query design grid I assume that you have already
linked the two tables by the Project Id field.
2. Add the Project ID field, Budget Amount field and the
Actual Amount field.
3. Click the Totals icon on the toolbar to display the
Total line in the query grid below the fields.
4. On the Total line for the Project ID set it to Group By.
Set the Budget Amount field Total line to First. Set the
Actual Amount field Total line to Sum.
This will accomplish what you are trying to do.
Note: You can change the field names in a query by typing
a new field name followed by :
Example, BUDGETAMT: YourFieldName
Instead of showing FirstOFBudgetAmount and
SumOfActualAmount.
Regards,
Eric T. Sherman