H harrisw Registered User. Local time Today, 00:17 Joined Mar 27, 2001 Messages 131 Jul 20, 2001 #1 How can I use the data from a query and put the result in a text box. I've tried the following but it doesn't work Me![Order Total] = [qryCalculateInvoiceCost]![SumOfPrice]
How can I use the data from a query and put the result in a text box. I've tried the following but it doesn't work Me![Order Total] = [qryCalculateInvoiceCost]![SumOfPrice]
R Rich Guest Jul 20, 2001 #2 If the form is based on the query then it's just =Sum([your field]) if it isn't then it's DLookUp. HTH
If the form is based on the query then it's just =Sum([your field]) if it isn't then it's DLookUp. HTH
H harrisw Registered User. Local time Today, 00:17 Joined Mar 27, 2001 Messages 131 Jul 20, 2001 #3 No I have a query that I want the text box to get its data from.
