Results 1 to 2 of 2
  1. #1
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141

    How to us count using TEXT in form

    I have a form made based on the below

    ID Email Customer Supplier Customer Name Customer Position Company Date Received Email Status Staff Name Int/Ext Telephone No Mobile No Text150
    480


    Customer


    30-Nov-2017 Inactive External


    481
    Customer


    30-Nov-2017 Inactive External


    2340
    Customer



    Inactive External


    3967
    Customer



    Inactive External


    3 Customer


    30-Nov-2017 Inactive External


    2197 Customer



    Active External


    6079 Customer Jeon Asst Manager Daewoo 14-Jan-2018 Active External



    Email status, Int/Ext and Customer Supplier are all dropdown.

    I want to count how many is inactive, active, external, internal, customer and supplier (all different boxes)

    my formula is as shown:

    =count(iff([int/ext]="Active",1))

    this shows a #ERROR

    Where is the error on this when i followed almost the same formula and it works on their project.

    any assistance and explanation is greatly appreciated.

    Trident

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,107
    Firstly the / in the field name is not a good idea, I would change it. In fact spaces and special characters are a pain and should be avoided at all costs.
    Secondly use a DCount() to get this

    Code:
    DCount("[Email Status]","YourTableName","[Email Status] = 'Active'")
    Obviously you may need additional criteria to get the correct result.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

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

Similar Threads

  1. Replies: 3
    Last Post: 08-21-2014, 09:48 AM
  2. Replies: 2
    Last Post: 02-19-2013, 10:36 AM
  3. Count IF Text Box for Dashboard
    By jvlajcic in forum Reports
    Replies: 1
    Last Post: 12-16-2011, 04:37 PM
  4. Count Text as Number
    By AccessFreak in forum Forms
    Replies: 1
    Last Post: 01-04-2011, 12:49 PM
  5. help with totals for count text boxes
    By gacapp in forum Reports
    Replies: 10
    Last Post: 07-22-2009, 11:26 AM

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