counting problem....

  • Thread starter Thread starter toby
  • Start date Start date
T

toby

Dear all,
how can i insert the excel function into the footer in access report ???
eg.: =sum(d1:d13)

how can i count the total value of a column (talking about items quantity)
in the access report each page individually?
thanks in advance
 
Toby

Access doesn't have "ranges" -- how do you plan to tell the Excel function
to identify a range (e.g., d1:d13)?

If you have a report defined in Access, with a control in the Details
section bound to an [UnderlyingField], you can add a control in the report
footer (page or report) and set its source to something like:

= Sum([UnderlyingField])
 
Back
Top