Results 1 to 2 of 2
  1. #1
    JSH2017 is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2017
    Posts
    3

    Using Expressions on a Form Issue

    Hello,
    I'm trying to add a build an expression in a text box on a form that references data from a query. Goal is to count the number of times "Win" occurs in a query under a column called "Result". In the expression builder I have tried the following and I'm getting an error and not sure the cause.

    Expression I tried to make:
    HTML Code:
    =Count([Query1]![Result])=["Win"]
    Error I received:
    #Name?


  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,911
    Investigate the DCount() function

    https://support.microsoft.com/en-us/...a-11a64acbf3d3

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

Similar Threads

  1. Replies: 2
    Last Post: 09-27-2017, 04:02 AM
  2. Replies: 8
    Last Post: 10-22-2015, 05:18 PM
  3. Complex Expressions on Form Too Slow - Any Better Way?
    By accessbeginner12 in forum Forms
    Replies: 4
    Last Post: 03-29-2013, 03:47 PM
  4. Expressions in Form
    By Deb4566 in forum Access
    Replies: 7
    Last Post: 03-08-2013, 12:18 PM
  5. Replies: 6
    Last Post: 06-19-2011, 02:16 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