Results 1 to 4 of 4

Thread: #error

  1. #1
    Join Date
    Sep 2003
    Posts
    10

    Angry Unanswered: #error

    im trying to make a report using access, and try to sum a field, a #error came up, what does that mean? how to fix it?

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    If you use a query as your RecordSource check whether it returns Data or not.

  3. #3
    Join Date
    Sep 2003
    Posts
    10
    yes it does, but the sum is not included in the select statement...so basically i just do = sum(fields)

  4. #4
    Join Date
    Jun 2004
    Location
    Terrapin Nation
    Posts
    205
    post your formula. is should be like =Sum([Your Field])

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •