Sequential Number on a Report

cbuccieri · Nov 30th, 2007, 14:24

I want to display a sequential line number on a report. I have read the solution on other posts. It seems so simple. But... It doesn't work for me.
I inserted a text box, set control =1, running sum over all.
When I switch to Print Preview, I get a dialog box asking for parameter value of the text box - I just his enter - and it goes away - and my report shows up. The text box is displayed with a zero on all lines.
So...
The solution doesn't work for me. What am I doing wrong?

cocoonfx · Dec 1st, 2007, 17:21

Hello

I build reports daily so i am hoping to help you out. What are you using excel,access, business objects?

Are you wanting to add a unique number to every row? As your post is not too clear.

cbuccieri · Dec 1st, 2007, 22:19

I am using Access 2000
I have a report where I display a list of items that are a result of a query.
I want to number the lines so that I have an easy way to reference the items.
ie. number 144 instead of page 6 line 4

cocoonfx · Dec 1st, 2007, 23:32

hello

Place a ID Number with an auto increment in the table of the main data. Make sure that the query has this this ID number and then it should automatically appear on your report.

I have attached a screen shot from Access 2007.

cbuccieri · Dec 1st, 2007, 23:58

Hmm
This will give me a sequential number of the records, but this report os the result of a query and does not include all of the records in the table so there would be gaps in the numbers.

cocoonfx · Dec 3rd, 2007, 12:33

Yes this is true,

How ever if you copy the query and change it to a make table you then can add a column to the query called id and then make this auto increment. You then have a the query based on this table. You can also get a macro to automatically update the make table query so that the report query is upto date all the time.

So the logic will be

Make Table Query - based on the rules of your origin query but add at the start of a query an id field ( ID_Query)

Then this will create a new table then create change the table on the original query to this new table but adding in the ID_Query to the query.

Then that will give you what you want.