Results 1 to 3 of 3

Thread: Counting the Records in Form

  1. #1
    Join Date
    Apr 2007
    Posts
    21

    Counting the Records in Form

    Hello,

    I have a form that contains some data and I would like to count them in a new Item text box ... I don't want to use the Item Text's property ... I want to use the SQL statement code to count the records in a form ... I named the Item Text as Count_Records ...

    So, Can I have your nice help in this (^_^)

  2. #2
    Join Date
    Apr 2007
    Posts
    21

    Hello

    Can anyone help!!

  3. #3
    Join Date
    May 2007
    Posts
    5

    counting the records in forms

    hellow meLady,

    Your question is slightly confusing... you haven't mentioned how the data in your forms comes eg. does it comes form the database or the user enters the data or you want to count the word/character within your form's textbox entered by user(s) or likewise....

    Well, if your records come from database than you can simply use the COUNT clause to count the records i.e

    SELECT COUNT(*) FROM TBL
    WHERE 1 = 1
    AND <COND1> = <COND2>

    and so on.... or you can simply initialize one variable and increment it within the loop and in next text box you can print the value of that variable.

    Thanks,
    spoons
    Last edited by spoons; 05-30-2007 at 11:49 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
  •