Hi all,
is it possible to display the record numbers in report.
please help me out
regards,
vsts
15 3148
Hi all,
is it possible to display the record numbers in report.
please help me out
regards,
vsts
Hi
Try putting a TextBox in the Report footer with a Control Source =Count([AnyFieldName])
??
MTB
Hi
thank you for your support... i want display the serial numbers of all records in report but not the total of record numbers
thank you
Hi
thank you for your support... i want display the serial numbers of all records in report but not the total of record numbers
thank you
Sorry, my mistake. I should read the question more closely.
Do you mean you want line numbers ?
If so then I suggest adding a field to the Record Source query Like
Line No: 1
and on the report display this field in a TextBox with the Running Sum property (on the Data Tab) set appropriately (ie. not No).
If that is not what you want then a little more info please!
MTB
Yes, I want line numbers only
but i am not getting it
can you explain me in detail please
vsts
Sorry, my mistake. I should read the question more closely.
Do you mean you want line numbers ?
If so then I suggest adding a field to the Record Source query Like
Line No: 1
and on the report display this field in a TextBox with the Running Sum property (on the Data Tab) set appropriately (ie. not No).
If that is not what you want then a little more info please!
MTB
Yes, I want line numbers only
but i am not getting it
can you explain me in detail please
vsts
OK, one step at a time; two questions
What is the Record Source of the report ?
And what don't you understand ?
MTB
Its related to salaries of the employees ... after entering the data in all fields i have to send one report to bank with all the net salaries of employees... the format is like this:
S.No. emloyee name bank number netpay
I need this s. no, column in report
OK, one step at a time; two questions
What is the Record Source of the report ?
And what don't you understand ?
MTB
Its related to salaries of the employees ... after entering the data in all fields i have to send one report to bank with all the net salaries of employees... the format is like this:
S.No. emloyee name bank number netpay
I need this s. no, column in report
Sorry if I am labouring the point, but it is important to know precisely what we are dealing with.
What is ‘SNo.’, is it data in the database related to the employee or just a line number that will always start at 1 ?
If ‘S.No.’ is employee data then report Record Source could be - SELECT 1 as LineNo, [SNo], [Employee Name], [Bank Number], [NetPay] FROM YourTableOrQuery
Then set the control with LineNo as the Control Source to RunningSum= Over All
If ‘S.No.’ is the line number then Record Source would/could be - SELECT [SNo], [Employee Name], [Bank Number], [NetPay] FROM YourTableOrQuery
with SNo as the Control Source to SummingSum= Over All
MTB
"S no." is the record number
i want to display the record numbers as serial number of that line
"S no." is the record number
i want to display the record numbers as serial number of that line
So,
what type of field is S.No.; number, integer ?
how is it entered; Autonumber, random, sequential ?
I am not sure that S.No. (with the full stops) is a valid field name !!
MTB
[its record number ... it must be an autonumber only
[its record number ... it must be an autonumber only
An autonumber field cannot be guaranteed to be sequential.
If that is the field you want to display, then I do not know want the problem (question) is !!
MTB
This is actually pretty easy in Access 2000/2003. In the report, create a unbound field, in the Detail area of the report. In the properties go to Other tab, type in RowCounter in the "Name". Flip back to the Data tab - in the "Control Source" put =+1 and in the "Running Sum" change to Over All. Preview the report - voila - numbered rows. Hope this does what you need.
thank you very much its working
Well, you learn somthing new every day!
MTB
This is actually pretty easy in Access 2000/2003. In the report, create a unbound field, in the Detail area of the report. In the properties go to Other tab, type in RowCounter in the "Name". Flip back to the Data tab - in the "Control Source" put =+1 and in the "Running Sum" change to Over All. Preview the report - voila - numbered rows. Hope this does what you need.
and even easier without running sum
using an unbound textbox in detail section set its controlsource to =[CurrentRecord]
Jim
Sign in to post your reply or Sign up for a free account.
Similar topics
by: mark |
last post by:
Access2000
How do I write a query that combines the CTC field from each record below into
one record? I need to concatenate the CTC field with a separator, like below:
...
|
by: Tony |
last post by:
I have a form in access that has 5 fields for a certain record: 1)Date
mailed, 2)Date received, 3)Date completed 4)Foreign Content amount and
5)record number. If the foreign content (FC)is >15% of...
|
by: sherkozmo |
last post by:
SQL2000 - AccessXP
I built an adp file with a stored procedure from SQL as follows:
SELECT * FROM
Z_mis_sjk_job_code_access
WHERE job_code=@JobCode
UNION ALL
SELECT * FROM...
|
by: systems analyst |
last post by:
This is my modification on an original solution posted by Trevor Best
(trevor@microprism.com) back in 1996.
Insert the following code in a Module in your Access data base.
Option Compare...
|
by: Will |
last post by:
I have a 1 page report which I want to print numerous copies of. The number
of copies will be specified by the user. My problem is that I want each
report to print the copy number of number of...
|
by: Chuck |
last post by:
Hi, I have a somewhat unique problem (at least unique to me, and I've
been doing this for longer than I care to admit). I have a client that
needs to print cards onto perforated card stock (so...
|
by: kkrizl |
last post by:
I have a form that displays general information about an alarm permit
location. There's a subform that shows detailed information about
burglar alarms that have gone off at the location. When a...
|
by: MLH |
last post by:
I have a source query (qryITSLetterList) feeding rows containing name,
addr, city, state, zip and VehicleID to a report (rptITSnotices). The
query may contain 1-to-5 records resulting in 1-to-5...
|
by: kaosyeti |
last post by:
hey... i have a form who's recordsource is a 3-field table. this form
prompts the user to enter a quarter and a year (which it then turns into a
date in an invisible control -- this control is...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
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...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |