473,320 Members | 2,122 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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 3958
ADezii
8,834 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,834 Expert 8TB
You are quite welcome.
Jan 23 '11 #4
Thanks for info
Jan 23 '11 #5

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

Similar topics

15
by: tom | last post by:
Hi, How do I get the serial number of the harddisk in .NET? I want this to be the same number even if the user has reformatted, so I do not want the volume serial number. Thanx, t
8
by: Mike MacSween | last post by:
tblCourses one to many to tblEvents. A course may have an intro workshop (a type of event), a mid course workshop, a final exam. Or any combination. Or something different in the future. At...
3
by: Peter | last post by:
Dear all, Would you tell me how to solve the following two problems in an access file upon preparing report form: a) I have written an IIf function for a string field at the beginning of...
2
by: dcyale | last post by:
I have a report with the following paragraph: ="This BA presents a " & & " determination for the " & & " and associated habitat. We would appreciate you processing the biological opinion by " &...
9
by: indrag91 | last post by:
i am retrieving 10 records out of 50 records from the access database using dataenvironment based on some condition. Now i want to place the serial number in the data report. Please give ur...
8
by: khursheed | last post by:
Hi experts! (Waiting for your reply) I want to print serial number or record number in access report while this field is not included in any table. Please help me
6
by: khursheed | last post by:
I want to print a report based on query SELECT * FROM employee WHERE age>50 I want to print serial number against each selected record in report. In FOXPRO I can do this by using function...
0
by: swamimeenu | last post by:
Hi, I need to add a automatic serial number in datareport in vb without having tht field in database.. but the remaining fields are connected from db... how to generate automatic serial number...
4
by: N2Deep | last post by:
I have a table named SUPPORT DATA, I have a field named Serial Number. In the Serial Number field I have many duplicates, and I only want one of each. Sample serials ABB045000MG, JBX05050016 ...
0
by: surkonsam | last post by:
Sir, In the report design , I cannot make a report that shows serial Number. Front end : visual basic 6.0 and back end : Ms access 2003. I don't know what to do. With regards sur
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.