Results 1 to 3 of 3

Thread: number records

  1. #1
    Join Date
    May 2012

    Unanswered: number records

    how to number records in a report generated from a query

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    Number records according to which criteria (i.e. what determines the order of numbering)?
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    what value should this number have, what is its purpose or meanng
    if its in a report then consider placing some code behind the forms events
    place a control on the report where you require it, almost certainly the reports detail section.

    declare a variable at the top of the reports code module
    if you want an ascending number set a value for that variable in the forms on load event
    then in the detail on format event add one to that varaibel and assign the value of that variable to the control you created earlier

    if you want to have blocks starting at one in each grouping then reset the value of the variable to zero in each relevant group header

    if you want the number of records in the report and or block then place a control in the relevent footer and assign the value as = count(mycontrolname) where mycontrolname is the name of the control you created in the reports detail
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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