Results 1 to 7 of 7

Thread: Report Error

  1. #1
    Join Date
    Nov 2005
    Posts
    13

    Unanswered: Report Error

    hi
    i have this report that displays the name and salary of the employees ...

    i have included a text field total salary and in the controal source of this field i included =Sum([salary])

    but when i display the report i get in the text field #Error

    can someone tell me where exactly is the error
    thankx

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Typo on the Column name???? Referencing a column that does not exist to the report?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try to substitute the text box with lable and use the caption property of the that lable

  4. #4
    Join Date
    Nov 2005
    Posts
    13
    Can you give an example please?

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    I'll send you an example using even a text box...

  6. #6
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try this simple example for groups sums in a report.....
    Attached Files Attached Files

  7. #7
    Join Date
    Apr 2006
    Location
    Huddersfield, UK
    Posts
    154

    Post

    Quote Originally Posted by nawaray
    hi
    i have included a text field total salary and in the controal source of this field i included =Sum([salary])
    This has happened to me before.

    In your report make sure you have the relevant groups (with headings and footers) set up and place your calculation in the footer of "Salary", this way it will know what it is running the sum of.

    Its worth a shot!

    Dan
    sometimes simple is best.... and i'm just a simple fellow.

Posting Permissions

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