Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    15

    Unanswered: Count Listbox Values on a Continuous Form

    I have a form that is set to view as "continuous" or a list of records.
    One of my fields is a list box with 3 values, Reserved, Wait List, Cancelled.

    At the bottom of my form I want to be about to count the total number of Reserved Records.

    I am trying to creat a text box with the control source as "=count([status].Itemdata(0))" but that gives an error

    "status" is the name of my list box field and 0 is my "Reserved" value

    any ideas?

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    try using count(iif(listbox = "reserved", 1, 0))
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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