record numbers in report

[vsts2007]

Hi all,
is it possible to display the record numbers in report.
please help me out

regards,
vsts

[MikeTheBike]

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

[vsts2007]

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

[MikeTheBike]

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

[vsts2007]

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

[MikeTheBike]

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

[vsts2007]

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

[MikeTheBike]

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

[vsts2007]

"S no." is the record number
i want to display the record numbers as serial number of that line

[MikeTheBike]

"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

[vsts2007]

[its record number ... it must be an autonumber only

[MikeTheBike]

[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

[geekspeak]

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.

[vsts2007]

thank you very much its working

[MikeTheBike]

Well, you learn somthing new every day!

MTB

[Jim Doherty]

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