Link form field from query 1

[VisaManiac]

I have a query that lists my order number and order total...

SELECT OrderNum, Sum([ProductPrice]*[Quantity]) AS OrderTotal
FROM OrderLines
GROUP BY OrderNum

Now, I'm trying to pull the OrderTotal field associated with that orderNum into my form, and my control source properties has the expression...

=[OrderLines_Calculation Query]!qryOrderSubTotal

But in form view it shows "#Name?" instead of my order total. Any suggestions why this might be? Input would be greatly appreciated!

Judy

 

[PHV]

Have a look at the DLookUp or DSum functions.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886