Resolving Enter Parameter Value message

[PeteD]

I am relatively inexperienced working with Access and am putting together a budget database for work. I built a query to display the amount of each line in the annual budget, the sum of the expenses against them, and added a calculated field to display the remaining balance (Budget - Total of expenses). The expression I used in the calculated field is: PO/Contract Balance: [Contract/PO Amount]-[SumOfInvoice Amount] where "Invoice Amount" is a field name in my expenses table. The part that has me confused is that this ultimately produces the correct result (below) however SumOfInvoice Amount is being treated as a parameter which is causing issues for me when producing reports in that the SumOfInvoice Amount column is blank even though PO/Contract Balance continues to calculate and display correctly. Been banging my head on my desk for a day now so any help is greatly appreciated. Thank you in advance!

Vendor Name	Contract/PO #	Contract/PO Amount	SumOfInvoice Amount	PO/Contract Balance
Vendor1	PO1	$50,000.00	$8,000.00	$42,000.00
Vendor2	PO2	$25,000.00	$3,500.00	$21,500.00
Vendor5	Contract5	$10,000.00	$250.00	$9,750.00
Vendor6	Contract6	$5,000.00	$1,200.00	$3,800.00

[greatwhite]

Although I don't see a spelling mistake in you comment, usually when it is treated as a parameter it's because it doesn't recognize the variable so double and triple check your spelling of the field.

[ranman256]

if [SumOfInvoice Amount] is a hard field, and NOT calculated, then the formula will work.

if you are trying to do a calculation on a SUM() then this may fail.
You can use the sum query in Q1, then in Q2 ,pull in Q1 and do the next calc :[Contract/PO Amount]-[SumOfInvoice Amount]

you will also get Param msg if a field is misspelled or non-existent.

[PeteD]

if [SumOfInvoice Amount] is a hard field, and NOT calculated, then the formula will work.

if you are trying to do a calculation on a SUM() then this may fail.
You can use the sum query in Q1, then in Q2 ,pull in Q1 and do the next calc :[Contract/PO Amount]-[SumOfInvoice Amount]

you will also get Param msg if a field is misspelled or non-existent.

Thank you! SumOfInvoice Amount was a SUM() not a hard field. Doing my SUM() in the first query and then bringing that into a second query works. Really appreciate your help.