Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2001
    Location
    New York
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count Function (Access97)

    In my report, I need to return the number of cases pending (field is called 'ComplaintServed' as of 10/31/01. Also # of cases dismissed for the month of October. I can't seem to get the correct syntax for these using the Count Function.

    Any help would be greatly appreciated.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count Function (Access97)

    I know this is a lazy way, but I find it saves me a lot of headaches. What I do is use the report wizard to make a new report with the items I want counted, counted. Then copy the formula to my report!

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Count Function (Access97)

    There's absolutely nothing wrong with that - I do it all the time. My view is the quickest way to get where I'm going is nearly always the best, especially if it's simple! <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Wendell

Posting Permissions

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