473,405 Members | 2,415 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,405 software developers and data experts.

How to start the record number with 100 in the place of 1 in access report?

mb60
37 32bit
In my access report the record number is starting from 1. I would like start with 100
Example
1. xxxxx
2.xxxxxx
but I want to begin with 100

100.xxxx
101.xxxx
102.xxx
I request your help.
Thank you
Jan 19 '11 #1
5 1624
Rabbit
12,516 Expert Mod 8TB
Add 100 to the control source that's displaying the record number.
Jan 19 '11 #2
mb60
37 32bit
sir
the first record is beginig with 100, but 2nd record with 200, 3rd one with 300
I want the increment of number as follows
101, 102,103 etc
Jan 19 '11 #3
Rabbit
12,516 Expert Mod 8TB
Add 100, not multiply. What did you put in the control source?
Jan 19 '11 #4
mb60
37 32bit
sir
In the control source of record number I put =100. Running sum ; Over all
Jan 19 '11 #5
Rabbit
12,516 Expert Mod 8TB
That wasn't what I meant. You need to put =[record number] + 100. No running sum. No over all.
Jan 19 '11 #6

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

Similar topics

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...
0
by: Scott269 | last post by:
So I've got an old MS Works database I imported into Access. I needed a primary key so I created a record number field that was just the record number I manually inserted when I entered it in the...
1
by: Scott269 | last post by:
So I've got an old MS Works database I imported into Access. I needed a primary key so I created a record number field that was just the record number I manually inserted when I entered it in the...
12
by: Wadim Grasza | last post by:
I want to store and display (on a form or a report) multiple pictures per record in an access database. The pictures are not stored within the database. They are stored as files and the database...
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 " &...
5
by: indrag91 | last post by:
hai, I want to get the record number in access using select statement. please help. Thanks in advance. indra.G
17
by: kkk1979 | last post by:
I have been using access as front end and SQL as Back end. I need help in generating an access report, by using a stored procedure with input parameters as record source. I tried the following...
1
by: Mcoleman | last post by:
Hi all My problem is this, I am trying to get my report which works fine, to open at a user specified place in the total amount of records. So in other words, when the user clicks the button to...
2
by: khani | last post by:
Hi i have following situation in cystal report in detail section i have a field say name.now i have five duplication record like this zahid zahid zahid zahid
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
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...

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.