Report/Query autonumber? (Access 2007)

[kujito]

First off:
(Boss = VP) > (Me = temp./part timer)
Boss is 70+ year old geologist, so cpu stuff is not his strong point. He just knows what he wants to see.

So, I finally got my queries to output the data I need. Now I'm trying to generate some reports for my Boss. He wants the first column to be a simple ordinal ItemNumber field that goes from 1 thru n for each record. The query data is sorted alpha. descending by ProjectName. The leftmost field is ProjectID and not sequential when sorted by ProjectName.
Looking for something like:
ItemNumber ProjectID ProjectName
1 109196 Agua Rica
2 105115 Aitik
... ... ...
n 117047 Zuun Mod

Is this something I can do in the report, or can I do it in the query?
Today is my last day with this company and I'd really like to finish this stuff up before I go.

TIA,
Brian

 

[Atomic Shrimp]

Does he want those numbers to always relate to the same data in the rest of the rows, or just to be a simple sequence of what is in this particular report?

If the former, it can be done with an autonumber in the underlying table, but you would have to accept gaps - partly because any report might not include all rows, but also, because autonumbers just don't always behave predictably.

If the latter, it might be possible with a 'running sum' (a running sum of the value 1) - there are lots of previous threads on this - although I haven't tried any of them, so I shan't recommend any in particular, but a search of the board on 'running sum' will get you some potential answers.

 

[kujito]

Thanks Mike.
I tried searching around a bit, but I wasn't even sure what exactly to search for.
I'll try the 'running sum' right now.

 

[kujito]

Denburt over on bytes.com shot me this link.
http://support.microsoft.com/kb/209567
Works like a charm

 

[Monoceros]

Hello,

I have Access 2007.

I tried this in a new report :

- created a control 'Number'
- Control Source : 1
- Running Sum : Over all

When I run the report, I get a popup box which asks 'Enter Parameter Value' for the filed 1.

When I fill in "1" (without the brackets) then the report shows always a 1 in the column, it doesn't add up.

When I fill in nothing (leave the popup box blank and click ok) then it shows a 0.

How can I do an autonumbering of the column for each record ?

It worked with Access 200, but doesn't seem to work in Access 2007 ?

 

[Monoceros]

Okay, I already found it.

Control Source must be "=1" without the brackets.