Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Query Counting (2000)

    Afternoon (GMT!), how can I structure a query to count multiple fields. For instance I have a query that has fields 'query' and 'level'. I need to return ouput that would show i.e. Query Type A = 4 of which Level = basic =2, intermediate = 2.

    Many thanks Darren.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Query Counting (2000)

    Darren

    Will a crosstab query be suitable for this...it may be. Have you got a stripped down version of you DB for us to look out(ie sensitive data removed or changed)
    Jerry

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Manchester, Gtr Manchester, England
    Posts
    552
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query Counting (2000)

    Thanks Jezza, absolute treat.

Posting Permissions

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