Results 1 to 3 of 3
  1. 06-21-2012, 12:22 PM #1
    Huddle
    Huddle is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Jun 2010
    Posts
    318

    DCount Syntax Correct?


    I'm using a DCount but it is returning 0 values is my syntax correct?

    =DSum("[PI_Post_Number]","[Tbl_PI_Post]","[FSL]=0")
    Reply With Quote Reply With Quote
  2. 06-21-2012, 12:29 PM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It syntax looks good to me assuming all of the three arguments are accurate values.
    http://access.mvps.org/access/general/gen0018.htm
    Reply With Quote Reply With Quote
  3. 06-21-2012, 03:06 PM #3
    TheShabz
    TheShabz is offline Court Jester
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2010
    Posts
    1,368
    Looks fine except for the DSum instead of your DCount.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. SQL Correct Syntax
    By tbassngal in forum Queries
    Replies: 11
    Last Post: 09-01-2011, 01:55 PM
  2. UPDATE Statement Correct Syntax
    By OMGsh Y did I say Yes in forum Forms
    Replies: 2
    Last Post: 02-23-2011, 01:42 PM
  3. Trouble with DCount syntax.
    By jessica.ann.meade in forum Database Design
    Replies: 9
    Last Post: 02-18-2011, 10:09 AM
  4. dcount syntax correct?
    By lbgtp in forum Reports
    Replies: 2
    Last Post: 12-29-2010, 10:01 AM
  5. What is the correct syntax for
    By giladweil in forum Access
    Replies: 1
    Last Post: 07-29-2010, 04:56 AM

Tags for this Thread

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums