469,326 Members | 1,534 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

How to begin serial number of the records from 100 in access report?

mb60
37 32bit
Sir
I would like start serial numbering from 100 in access report. For example
100) xxxxxxxx
101) zzzzzzzz
102) yyyyyyyyy
Earlier I asked the same question. Expert Sri Rabbit helped in this regard but there might be some mistake from my side in using his suggestion. Once again I request your help in this regard
Thank you
Jan 21 '11 #1

✓ answered by ADezii

  1. Create a Text Box in the Detail Section of a Report. For the sake of argument, we'll call it Text50.
  2. Delete the associated Label for this Text Box (Text50).
  3. Set the Control Source of this Text Box '=1'.
  4. Set the Running Sum of Text50 = Over All.
  5. Set the Visible Property to No.
  6. Create another Text Box on a Form (Detail Section) where you would like to see the Running Totals (100, 101, 102, etc.). Let's call this Text Box txtTotals.
  7. Set the Visible Property of txtTotals = Yes.
  8. You can also delete the associated Label for txtTotals if you like.
  9. Set the Running Sum of txtTotals to No.
  10. Set the Control Source of txtTotals =[Text50]+100.

4 3595
ADezii
8,800 Expert 8TB
  1. Create a Text Box in the Detail Section of a Report. For the sake of argument, we'll call it Text50.
  2. Delete the associated Label for this Text Box (Text50).
  3. Set the Control Source of this Text Box '=1'.
  4. Set the Running Sum of Text50 = Over All.
  5. Set the Visible Property to No.
  6. Create another Text Box on a Form (Detail Section) where you would like to see the Running Totals (100, 101, 102, etc.). Let's call this Text Box txtTotals.
  7. Set the Visible Property of txtTotals = Yes.
  8. You can also delete the associated Label for txtTotals if you like.
  9. Set the Running Sum of txtTotals to No.
  10. Set the Control Source of txtTotals =[Text50]+100.
Jan 22 '11 #2
mb60
37 32bit
Thank you sir
I got it.
Jan 23 '11 #3
ADezii
8,800 Expert 8TB
You are quite welcome.
Jan 23 '11 #4
Thanks for info
Jan 23 '11 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

15 posts views Thread by tom | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.