Sum a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to use the sum Function to sum a field but the field has a
"Dlookup" expression and the sum function returns "errors".
How should i do ??????????????
 
Do you want the sum of current records displayed? Where do you want the sum
to go? =Sum([NameOfField]) I simply type this into a blank box. If you
want to go to the table to look up the sum then you have to use dlookup. If
you want to see the sum of a form or report you use this (above).
 
I've try it before and is the same answer = #errors


Bryan said:
Do you want the sum of current records displayed? Where do you want the sum
to go? =Sum([NameOfField]) I simply type this into a blank box. If you
want to go to the table to look up the sum then you have to use dlookup. If
you want to see the sum of a form or report you use this (above).

Chouenneu said:
I'm trying to use the sum Function to sum a field but the field has a
"Dlookup" expression and the sum function returns "errors".
How should i do ??????????????
Click to expand...
Click to expand...
 
I want to Sum([Total]) where Total =[Quantity]*[UnitPrice] and where
UnitPrice =DlookUp("[UnitPrice]","Products","[List of Products by
Project]![ProductName] = [ProductID]")

Bryan said:
Do you want the sum of current records displayed? Where do you want the sum
to go? =Sum([NameOfField]) I simply type this into a blank box. If you
want to go to the table to look up the sum then you have to use dlookup. If
you want to see the sum of a form or report you use this (above).

Chouenneu said:
I'm trying to use the sum Function to sum a field but the field has a
"Dlookup" expression and the sum function returns "errors".
How should i do ??????????????
Click to expand...
Click to expand...
 
Back
Top