By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,482 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,482 IT Pros & Developers. It's quick & easy.

Report/query autonumber field? (Access 2007)

P: 19
Ok, here it goes.
I got my queries straightened out and they return the data I want in the format I want(finally). The data are sorted alpha. descending by ProjectName. Each project has a unique ProjectID, which is the left-most field. Sorting by ProjectName means that the ProjectID field is not in numerical order.
ProjectID
109156
105428
2812
117973
The boss wants to have an ordinal number field called something like 'ItemNumber' and is simply
1
2
3
...
n

How can I go about this? Can I make the Query generate such a field? Is it something that I can do in the Report? The only place it MUST be is in the Report, but there is no problem if it is in the query as well.

TIA,
Brian

p.s.
(Boss = VP) > (Me = Temp./Part-timer)
May 15 '09 #1
Share this Question
Share on Google+
10 Replies


beacon
100+
P: 579
Hi kujito,

You might want to check out this link: ** Link removed as per site rules **

I couldn't get it to work properly for me (the function will continue to increment if you navigate around in the query), but it may get you headed in the right direction. I may mess with it later if I have time.
May 15 '09 #2

Denburt
Expert 100+
P: 1,356
For sequentially numbering the records in a report you can take a look at this article here:
http://support.microsoft.com/kb/209567
May 15 '09 #3

P: 19
Thanks Denburt!
Perfect!
May 15 '09 #4

Denburt
Expert 100+
P: 1,356
Glad to be of help. Let us know how things go.
May 15 '09 #5

P: 19
Good so far. Just fumbling around in design view to get it arranged the way Bob wants.
I hate Access. The simple stuff is way too hard! :D
May 15 '09 #6

Denburt
Expert 100+
P: 1,356
@kujito
Takes a little getting used to it but it can be a very powerful tool. After you spend some time getting used to it you just might find it can be fun MS Access can do some pretty neat stuff.
May 15 '09 #7

P: 19
I actually use it quite often. It's the dbms underlying ESRI's ArcGIS Desktop. It's mainly the way this particular one was set up (by a third party). Not necessarily wrong, just a little clunky sometimes.
May 15 '09 #8

Denburt
Expert 100+
P: 1,356
Ah that explains it, I have actually worked with their software in the past probably 10 years ago or so. I completely understand your frustration I believe a lot of companies like this one design their databases with the sole purpose of having people like us run around in circles like we are in an egg hunt or something. Good luck
May 15 '09 #9

P: 19
lol
I keep finding cracked eggs.
May 15 '09 #10

NeoPa
Expert Mod 15k+
P: 31,709
Simply :-
Add a Textbox with a value of one (1), then set the Running Sum property to Yes.
May 26 '09 #11

Post your reply

Sign in to post your reply or Sign up for a free account.