Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002
    Posts
    8

    Unanswered: variables in aggregate functions

    How do i use a variable in an aggregate functions such as DCount

    Thanks in advance

  2. #2
    Join Date
    Sep 2002
    Location
    Coventry, Warwickshire, UK
    Posts
    74
    It depends on where you want to use the DCount function. Could you elaborate further.
    Roger Hampson
    XI - ecs (UK) Ltd

  3. #3
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Is this what you're after?

    DCount(strFieldName, strTableName, "[Country] = '" & strCountry & "'")

  4. #4
    Join Date
    Oct 2002
    Posts
    8
    That is exactly what i'm after. Thanks guys. Although it seems simple now that doesn't mean i would have ever thought of it ;o)

Posting Permissions

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