Results 1 to 2 of 2

Thread: generating an serial number field in data report

  1. Jul 4th, 2008, 01:47 PM #1
    pulkit gulati
    pulkit gulati is offline

    Thread Starter
    New Member
    Join Date
    Jun 2008
    Posts
    8

    Question generating an serial number field in data report

    Hello,
    I am using data report in vb 6.0 and I have to show the extracted records with serail no. auto-incremented. I cannot use the ID from the database since it is an auto-number and if a record is deleted, the records loose their continuity.

    Plz Help!!!!
    Thanks in advance!!!!!!!
    Reply With Quote Reply With Quote
  2. Jul 4th, 2008, 08:27 PM #2
    rasinc
    rasinc is offline
    Hyperactive Member
    Join Date
    Jul 2007
    Posts
    479

    Re: generating an serial number field in data report

    Have you tried using the Special Field called Record Number? I've never used it but it will probably do the trick. Otherwise, you can create your own formula that increments a shared variable from a specific starting number.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width