Calculated fields in Access

in acces build a query and as an advanced criteria you can select to sum it all

so i would build a calculated field in a query and sum that

In the grid, show the totals row. Put the PO number in the far left column and click 'Show'. Then, in the next column, put the calculated field. Like:
TotalforThisPO: SUM([Table].[POValue]) and show this field. Any other criteria needs to be in subsequent columns (to the right).

This code is kinda lengthy, but it calculates the total of the project changes that are approved for specific projects. I get two columns - one for the project and one for the total project changes.

SELECT [dbo_tProject].[sProjectCode], Sum([dbo_tDocumentAllocation].[Nvalue1]*[dbo_tDocumentAllocation].[nRoE]) AS TotalValue
FROM (dbo_tProject INNER JOIN ((dbo_tDocumentAllocation INNER JOIN dbo_tBudgetItem ON [dbo_tDocumentAllocation].[iBudgetItem]=[dbo_tBudgetItem].[idBudgetItem]) INNER JOIN (dbo_tDocument INNER JOIN dbo_tDocumentType ON [dbo_tDocument].[iDocumentType]=[dbo_tDocumentType].[idDocumentType]) ON [dbo_tDocumentAllocation].[iDocument]=[dbo_tDocument].[idDocument]) ON [dbo_tProject].[idProject]=[dbo_tBudgetItem].[iProject]) INNER JOIN dbo_tDocumentStatus ON [dbo_tDocument].[iDocumentStatus]=[dbo_tDocumentStatus].[idDocumentStatus]
GROUP BY [dbo_tProject].[sProjectCode], [dbo_tDocumentStatus].[sDesc], [dbo_tDocumentType].[sDesc]
HAVING (((dbo_tProject.sProjectCode) Like "*0534*") AND ((dbo_tDocumentStatus.sDesc)="Approved Change") AND ((dbo_tDocumentType.sDesc)="Project Change"))
ORDER BY [dbo_tProject].[sProjectCode];

Hope this helps.
Laurel