Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula for Adding names on a report (XP)

    Hi,

    I have a report with a list of student names - two fields, last name and first name. I would like to have the total of students listed at the bottom of the report. I tried using COUNT for last names but I keep on getting a syntax error. Can anyone help me out? Thanks.

    Dorothy

  2. #2
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Formula for Adding names on a report (XP)

    If it's simply a syntax error, you might try:
    =Count([txtStudentName])
    replacing "txtStudentName" with the name of the text box on the report.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula for Adding names on a report (XP)

    Thank you. I gave it a try using the following: =Count([txtTbl Students.Last_Name]), as tbl Students.Last_Name is in the textbox of the detail portion of the report listing the last names. I am not getting a dialogue box stating that there is an error now, but when I open the report it shows the word error in the text box. Any ideas? Thanks again.

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula for Adding names on a report (XP)

    Also tried =Count([Tbl Students.Last_Name]) and still shows "error" on the report in the text box.

  5. #5
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Formula for Adding names on a report (XP)

    Are you certain of the text-box name? (view the report in design view and look at the exact name of the text-box containing the student names). I'm curious about this because the name you have entered is somewhat odd as far as naming conventions go. If what you have entered is exactly and precisely the name of the correct name of the text-box, then you may be trying to place the unbound text-box in the wrong area of the report - it should be in the page footer (or perhaps in a footer specific to the group you are trying to calculate). Post back if you are certain that you have named the reference correctly, because if you still experience an error it is likely caused by the location of the unbound text-box.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formula for Adding names on a report (XP)

    You must put the text box in the report footer, not in the page footer of the report. A simpler expression that counts records is

    =Count(*)

  7. #7
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula for Adding names on a report (XP)

    Thank you, thank you, thank you. I had it in the page footer. Worked once I placed in the report footer. Yea!!!

  8. #8
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: Formula for Adding names on a report (XP)

    Hans:

    Ooops. I meant report footer, but my fingers didn't agree (too many irons in the fire here).
    Sorry if I mislead you Dorothy!
    <img src=/S/innocent.gif border=0 alt=innocent width=20 height=20>
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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