I am trying to put a summary field at the end of a report, but the field is from another database so I can't use the summary calculation. I tried using a regular calculation (sum (Clerking:price)), but that just gave me the last number in the report. How can I get a summary price for the report?

You need to create a new relationship. But we need more info about what is summaried in the report...

I have a [price] field in the clerking database and in the main inventory database I have the same field [price] from clerking showing up as a related field. I need to run a report in Inventory showing the price with a summary total at the bottom.