Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    49

    Unanswered: Total number of entries contacting "sales"

    Hello,
    I want to do a SQL lookup of how many entries there is in the DB called "sales" under the department column. Whats the command to do the lookup?


    John

  2. #2
    Join Date
    Nov 2005
    Posts
    49
    something like...

    =DSum("howmany","total","department = sales")

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    how many entries there is in the table (not DB)

    dcount("department", "theNameOfYourTable", "department = 'sales'")

    izy
    currently using SS 2008R2

Posting Permissions

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