HOW TO INSERT RECORD NO

[CHANDU V]

Hai,

i want record number in access report. how to insert record number in access report.


thanks in advance.


regards

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Stefan Hoffmann]

hi,

i want record number in access report. how to insert record number in access report.

You can create an artificial set number when you have a candidate key
for your order:

SELECT *,
(
SELECT Count(*)
FROM Table I
WHERE I.CandidateKey < O.CandidateKey
)
FROM Table O
ORDER BY CandidateKey

Depending on the realation < or <= your set number starts with 0 or 1.

mfG
--> stefan <--

 

[Guest]

There is no such thing as a record number in Access. There is an Absolute
Position property of a record in a recordset; however, that is not a static
value. Record number change in a recordset depending on ordering and
filtering. Although the Absolute Positiion may be of value in VBA coding
when manipulating a recordset, in the "real" world, they actually have no
meaning and no value.

 

[Duane Hookom]

I assume you want something completely different from other repliers. If you
want to number the output of your records in your report,
1) add a text box to the detail section
2) set the Control Source to
=1
3) set the Running Sum property to Over All or Over Group
depending on your needs.

 

[Guest]

In the text box type this expression in the control source: =1 and set the
Running sum to over the group in the property of the text box.

I hope you understand what i mean. Do let me know if this is helped you.