Results 1 to 2 of 2

Thread: Counting items

  1. #1
    Join Date
    Mar 2004
    Location
    Greenville, SC
    Posts
    271

    Unanswered: Counting items

    We have a sheet we fill out as a checklist with check boxes:

    Job Foreman Date Filled in name Filled in time
    JBA Tom 2/2/04
    CRU Will 3/2/04
    PWA Tom 6/24/04 o


    I want to be able to enter a text box that will count the number of (yes or trues) in the "Filled in name" and the "Filled in time".
    I just don't know what to enter in the control source of my text box to count them??

    Any help would be great!!

    Michael
    Gotta to do some code

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    WTF?

    Code:
    We have a sheet we fill out as a checklist with check boxes:
     
    Job	Foreman    Date       Filled in name     Filled in time
    JBA	Tom         2/2/04
    CRU	Will        3/2/04
    PWA	Tom         6/24/04
     
     
    I want to be able to enter a text box that will count the number of  (yes or trues) in the "Filled in name" and the "Filled in time".
    I just don't know what to enter in the control source of my text box to count them??
     
    Any help would be great!!
     
    Michael:confused:

    Perhaps

    =SELECT COUNT(*) FROM yourTable99 Filled IS NOT NULL
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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