I have a result list from a sport arrangement. This is shown in a report. To show the placement I have a textbox with the expression "=1". That result in first records from my query get the number 1 in the textbox, second record get 2 third get 3 and so on. However, sometime this is fault.
Imagine record just contain NAME and the result TIME. If two results have the same (time(3)=time(4)), I still will get 1, 2, 3, 4, 5, 6 , and so on in the textbox, but it should have been 1, 2, 3, 3, 5, 6. Anybody who has a smart trick for this? May be some of you have a smarter way to solve this "problem"?
Bombus
3 1281 PEB 1,418
Expert 1GB
Hi,
You have done it super good! For more you need reelly use a function!
:)
I have a result list from a sport arrangement. This is shown in a report. To show the placement I have a textbox with the expression "=1". That result in first records from my query get the number 1 in the textbox, second record get 2 third get 3 and so on. However, sometime this is fault.
Imagine record just contain NAME and the result TIME. If two results have the same (time(3)=time(4)), I still will get 1, 2, 3, 4, 5, 6 , and so on in the textbox, but it should have been 1, 2, 3, 3, 5, 6. Anybody who has a smart trick for this? May be some of you have a smarter way to solve this "problem"?
Bombus
-------------
Microsoft's web site http://support.microsoft.com/kb/q208946/ has good sample queries and result pictures that show how to number and rank your data.
Thank You jkantner.
That was a good link. Exact what I was looking for. Thanks a lot. I thought I had to do a lot of programming, but this was quite easy.
Bombus
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Marek |
last post by:
When I use "list-style-type:decimal;" in Mozilla I get numbering only with
"zero":
0. aaaa
0. bbb
0. cccc
Why there is no incrementation?
In IE 6.0 there is no numbering:
aaaa
bbb
cccc
|
by: Stanimir Stamenkov |
last post by:
So if the 'type' attribute of the OL element is deprecated and
authors should rely only on stylesheets how one could use a
reference (as clear text) in the content to a particular list element?
...
|
by: Wayne Aprato |
last post by:
I have a report that shows the results of a query. One of the fields
is an autonumber field from the query which shows for instance: 120,
121 , 122 for 3 records. Is there a way to have another...
|
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...
|
by: Rob |
last post by:
Hi,
I have an access 2000 application.I generate a report with Query
as the recordsource.This report is the analysis of data Vendorwise.The
vendors are listed in ascending order...
|
by: Elasho |
last post by:
I have a report that groups data on an Area, the report is set to force a
new page for each Area within the report.
Each Area will have 1 or more pages.
Is it possible to make the page...
|
by: Simon |
last post by:
Dear reader,
Most of the reports have a page numbering as Page x of nn, starting at the
first page 1 (one) to the last page nn.
But know I need to start with Page 1 of nn for each...
|
by: joelpollock |
last post by:
I'm having trouble continuously page numbering a large report in MS
Access. The report is made up of three separate Access reports which I
join together at the end.
In the past I have opened the...
|
by: seawolf |
last post by:
Is there a way to create a numbering for the Details in an Access 2003 Report. For instance, if a report has 12 records that make up the Details in a report, can these be numbered, i.e., 1, 2, 3, 4,...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |