Numbering in Reports (or Queries)

  • Thread starter Thread starter Jesse Krolik
  • Start date Start date
J

Jesse Krolik

Hi,

I have a report and I want it to print the number of each
record. Ie: The first line to have "1.", the seond line
to have "2."

How do I do this?

Do I have to do something to the query the report is
coming from?

Or is there something I can do to the report?

Thanks!
 
The easiest method is to add a text box in the report:
Control Source: =1
Running Sum: Over Group (or Over All)
 
Hi -

Thanks! It worked!

Just for curiosity - how would I do the same thing if I
wanted to print a Query?

Jesse
 
You could use a subquery in the query.
SELECT Score,
(SELECT Count(*)
FROM tblScores S
WHERE S.Score <=tblScores.Score) as Rank
FROM tblScores;
 
Back
Top