Results 1 to 2 of 2
  1. #1
    bishmedia is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    44

    control source expression error

    I'm, sure this is a simple question, I have locations setup and I need to count the number of locations between 2 points in a control source, I'm trying the following but im getting an expression error

    =Count(IIf([LocationMaster]>"JZ023A" and < "JZ080A",0))



    Can anyone point me in the right direction

  2. #2
    bishmedia is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    May 2018
    Posts
    44
    It's ok, sorted it myself...
    =Count(IIf([LocationMaster]>"JZ023A" And [LocationMaster]<"JZ080A",0))

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

Similar Threads

  1. Add string to expression in Control Source
    By jmitchelldueck in forum Reports
    Replies: 5
    Last Post: 07-20-2015, 06:10 PM
  2. Replies: 6
    Last Post: 05-17-2015, 01:22 PM
  3. Control source Expression giving #Error
    By N3w2access in forum Forms
    Replies: 5
    Last Post: 01-21-2014, 07:53 AM
  4. Replies: 3
    Last Post: 04-30-2013, 05:32 AM
  5. Textbox Control Source As An Expression help!
    By emilyrogers in forum Forms
    Replies: 11
    Last Post: 02-11-2011, 07:31 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
  •  
Other Forums: Microsoft Office Forums