referring to external fields from report

[buddythebest]

when i try to refer to external fields to use in calculations in a report it always asks "enter parameter value". Like i have a field in the report called "sales", and i have "total price" in another form called "sbfrmOrders". I want to calcualte the percentage of total sales by dividing "sales" by the sum of the "total price"
i tried to do it using this formula:
=[Sales]/Sum([Forms]![sbfrmOrders]![Total price])
but it didnt work as it asks for a value to put in which is already stored in the "sbfrmOrders" form. (it had the enter parameter value window with this "Forms!sbfrmOrders!Total price" over the blank space where i enter the value, i dont want to enter the value i want it to be taken from the form straight away)

how can i resolve this... please offer your help if u can

thank you

 

[Pat Hartman]

The form must be open to reference fields on it.

Your method is flawed since you can only refer to the form's current record by this method.

Proper technique would be to create a query that creates the summed values and then create another query that joins the totals query to the main table and use that query as the recordSource for the report.

 

[buddythebest]

thanx ill try that (although i've tried something similar before which didnt work)

 

[buddythebest]

thanx its working perfectly now... it seems that reports just dont allow calculations which include external fields