All About Context

Hi Scott,
I have uploaded the query. What I am trying to do is e.g. to get each Members funding amount for a particular work package. Vendor Cost/Sum of all Member Shares * Member share. This amount to display on the form. The footer in the form to sum up the amount for each work package. I have also uploaded the query result.

Taruna
The Query results can't display totals in each column like excel. (I'm assuming that is what you are trying to do)
If that is the case you need to use that query as the data source for a continuous form. Then put your totals in the forms footer.

See the Form Footer Totals video for info on how to accomplish this.
If I didn't understand you correctly please restate your question with a little more detail.

Your other alternative is to use that query to create an Aggregate Query

It was pulling the query results in the form but the totals in the footer, however that did not work. Do I need to total using another query and display results in footer?

Is the name of the field you are trying to sum up correct?

Hi Kevin,
In the Footer I had put text box field name i.e. MemVenCost =Sum([MemVenCost])  also I tried the Query field name MVC.