Results 1 to 3 of 3
  1. #1
    printsol is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Sep 2021
    Posts
    33

    dcount

    hi
    can any body figure out, its not working

    =DCount("*","Students","Students.Sclass=1 and Students.Ssection=A")



    =DCount("*","Students","Students.Sclass=" & 1 and "Students.Ssection=" & "A")



    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,522
    string values must be surrounded by quotes (while inside quotes):

    =DCount("*","Students","Sclass=1 and Ssection='A' ")

  3. #3
    printsol is offline Advanced Beginner
    Windows 10 Access 2010 64bit
    Join Date
    Sep 2021
    Posts
    33
    thanks
    ranman256

Please reply to this thread with any new information or opinions.

Similar Threads

  1. dCOUNT HELP
    By www in forum Access
    Replies: 5
    Last Post: 02-04-2019, 06:20 PM
  2. Dcount and between
    By Clexidr@ in forum Access
    Replies: 2
    Last Post: 07-27-2017, 09:01 AM
  3. DCount
    By nsteenhaut in forum Queries
    Replies: 2
    Last Post: 10-04-2011, 05:00 PM
  4. DCount and If
    By Madmax in forum Access
    Replies: 3
    Last Post: 07-28-2011, 06:53 AM
  5. DCount and SQL
    By DSTR3 in forum Queries
    Replies: 3
    Last Post: 12-06-2010, 03:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums