473,325 Members | 2,771 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Report/query autonumber field? (Access 2007)

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
10 5041
beacon
579 512MB
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
1,356 Expert 1GB
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
kujito
19
Thanks Denburt!
Perfect!
May 15 '09 #4
Denburt
1,356 Expert 1GB
Glad to be of help. Let us know how things go.
May 15 '09 #5
kujito
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
1,356 Expert 1GB
@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
kujito
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
1,356 Expert 1GB
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
kujito
19
lol
I keep finding cracked eggs.
May 15 '09 #10
NeoPa
32,556 Expert Mod 16PB
Simply :-
Add a Textbox with a value of one (1), then set the Running Sum property to Yes.
May 26 '09 #11

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

Similar topics

6
by: John | last post by:
Hi, I have simple database based on 3 tables. Relationship is 'one to many' between table 1 and 2, also between 2 and 3 table'one to many'. I have made form where I enter data in all 3 tables....
2
by: Wayne Aprato | last post by:
I posted this yesterday and it seems like a moderator has thrown it in another thread. This is a totally different question to the one asked in that thread, so I'm posting it again. It is not a...
1
by: Nathan Bloomfield | last post by:
Does anyone know if there is any documentation which relates to Access2k + ? or can anyone help adjust the code? I am having trouble converting the DAO references. TITLE :INF: How to...
6
by: Mike Conklin | last post by:
This one really has me going. Probably something silly. I'm using dcount for a report to determine the number of different types of tests proctored in a semester. My report is based on a...
2
by: braley | last post by:
I am using MS Access 2003 and am in the process of creating a database that contains contact information and attendance data for a group of volunteers. I have created a table that contains all of...
1
by: tonyaccess | last post by:
Hi, I hope you may be able to help a coding novice. I have a fairly simple db which extracts data to a report via a query, my problem is the report is three pages per record set and a total of...
5
by: ladybug via AccessMonster.com | last post by:
I am trying to create a report using multiple tables. The first table has Employee info in it (name and id's). the next three tables have employee info for training, test, scores, etc. I am...
4
by: irkahs | last post by:
Hello all, I have a report which is connected to a query that collects data based on some filters. Now, my question is, how do I make an autonumber starting from 1 get generated...
5
by: LadyIlsebet | last post by:
I'm not a fantastic Access developer, but I'm trying to help get Inventory and whatnot organized at work. They are used to 5 year budget plans that list out exactly what has to be purchased what...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.