Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counts on a report (Access 97)

    I would like to count the number of fields on a report based on a criteria. I can count the number of fields by using =Count([Text1]) on a fields record source. But how can I say Count only the fields whose value is N? I know this can be done on a query but can it done on a report? Thanks...

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counts on a report (Access 97)

    In the footer of the report you can use a textbox with control source :
    =Sum(IIf([Text1]="N",1,0))
    This will return the number of N's

    edit to correct syntax error
    Francois

Posting Permissions

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