Hi!
I've got a sport-database for my students with
name - class - teacher - year of birth - 60meter-runningtime - 100meter
- longjump - ...(and some other disciplines)
The whole program itself is running great, i have reports to filter the
best in each discipline and I can set a filter for the class, for the
number of students to be shown in the reprts and some others.
As for here, quite okay
Now, there gonna be some competitions and my colleagues and I have to
pick out the best students and tell them to take part in these
competitions.
So, we need a report, which is sortet by class.
And in each age-group the best 5(the number should be taken out of a
form)
in each discipline shout be filter out of the whole database.
At time a made it with an "INSERT INTO"-Query for each discipline, don't
know the english word for it.
So I've got a new table with the data.
But those at the time 5 "INSERT INTO"-Queries take so long...
One of thise queries looks like this:
INSERT INTO tblKlassendruck ( 60m, Jahrgang, Klasse, Zuname, Vorname,
Lehrkraft, Rang )
SELECT qry60m.[60m], qry60m.Jahrgang , qry60m.Klasse, qry60m.Zuname,
qry60m.Vorname, qry60m.Lehrkraf t, (Select Count (*) FROM [qry60m] as X
WHERE [X].[60m]<[qry60m].[60m])+1 AS Rang
FROM qry60m
WHERE ((((Select Count (*) FROM [qry60m] as X WHERE [X].[60m]<[qry60m].
[60m])+1)<=[Formulare]![frmLA]![txtAnzahl])) OR (((((Select Count (*)
FROM [qry60m] as X WHERE [X].[60m]<[qry60m].[60m])+1)<=[Formulare]!
[frmLA]![txtAnzahl]) Is Null));
Can someone help me to advance my database?
I could also send the db with some data to show, what i mean.
ICQ-Uin also available.
I'm working on WinXP Sp2, Access 2000/XP
thank you in advance!
mathew 2 1337
Greier Matthias wrote: Hi!
I've got a sport-database for my students with name - class - teacher - year of birth - 60meter-runningtime - 100meter - longjump - ...(and some other disciplines)
The whole program itself is running great, i have reports to filter the best in each discipline and I can set a filter for the class, for the number of students to be shown in the reprts and some others.
As for here, quite okay
Now, there gonna be some competitions and my colleagues and I have to pick out the best students and tell them to take part in these competitions.
So, we need a report, which is sortet by class. And in each age-group the best 5(the number should be taken out of a form) in each discipline shout be filter out of the whole database.
At time a made it with an "INSERT INTO"-Query for each discipline, don't know the english word for it.
So I've got a new table with the data. But those at the time 5 "INSERT INTO"-Queries take so long...
One of thise queries looks like this:
INSERT INTO tblKlassendruck ( 60m, Jahrgang, Klasse, Zuname, Vorname, Lehrkraft, Rang ) SELECT qry60m.[60m], qry60m.Jahrgang , qry60m.Klasse, qry60m.Zuname, qry60m.Vorname, qry60m.Lehrkraf t, (Select Count (*) FROM [qry60m] as X WHERE [X].[60m]<[qry60m].[60m])+1 AS Rang FROM qry60m WHERE ((((Select Count (*) FROM [qry60m] as X WHERE [X].[60m]<[qry60m]. [60m])+1)<=[Formulare]![frmLA]![txtAnzahl])) OR (((((Select Count (*) FROM [qry60m] as X WHERE [X].[60m]<[qry60m].[60m])+1)<=[Formulare]! [frmLA]![txtAnzahl]) Is Null));
Can someone help me to advance my database? I could also send the db with some data to show, what i mean. ICQ-Uin also available.
I'm working on WinXP Sp2, Access 2000/XP
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I'm not complete sure, but something like this:
INSERT INTO tblKlassendruck ([60m], Jahrgang, Klasse, Zuname, Vorname,
Lehrkraft, Rang )
SELECT [60m], Jahrgang, Klasse, Zuname, Vorname, Lehrkraft,
(Select Count(*) FROM [qry60m]
WHERE [60m]<[qry60m].[60m])+1 AS Rang
FROM qry60m
WHERE (SELECT Count(*)
FROM [qry60m]
WHERE [60m]<[qry60m].[60m])+1 <=
[Formulare]![frmLA]![txtAnzahl]
OR [Formulare]![frmLA]![txtAnzahl]) Is Null
The WHERE clause needed correction: the OR phrase was trying to
determine 2 conditions at one time, which is impossible.
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQnaGM4echKq OuFEgEQJHYwCbBf GXtSsz3trOTPcvC T+wkI7yNTwAn1lC
o1BKFIbJhzBPFp/HD8AS3HMd
=uIZv
-----END PGP SIGNATURE-----
MGFoster <me@privacy.com > wrote in
news:MC******** *********@newsr ead1.news.pas.e arthlink.net: I'm not complete sure, but something like this:
INSERT INTO tblKlassendruck ([60m], Jahrgang, Klasse, Zuname, Vorname, Lehrkraft, Rang ) SELECT [60m], Jahrgang, Klasse, Zuname, Vorname, Lehrkraft, (Select Count(*) FROM [qry60m] WHERE [60m]<[qry60m].[60m])+1 AS Rang FROM qry60m WHERE (SELECT Count(*) FROM [qry60m] WHERE [60m]<[qry60m].[60m])+1 <= [Formulare]![frmLA]![txtAnzahl] OR [Formulare]![frmLA]![txtAnzahl]) Is Null
The WHERE clause needed correction: the OR phrase was trying to determine 2 conditions at one time, which is impossible.
Hi! Thanks you for your reply!
But the query itself works perfect! So I think it's okay like it is.
Maybe I can send you a sample how it works...
Just drop me a line
Thanks
Mathew This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Joh |
last post by:
Hello,
(sorry long)
i think i have missed something in the code below, i would like to
design some kind of detector with python, but i feel totally in a no
way now and need some advices to advance :(
data = "it is an <atag> example of the kind of </atag> data it must
handle and another kind of data".split(" ")
|
by: solartimba |
last post by:
I am using the advance() auxiliary STL iterator function to move a map
iter forward, but I read that there is no check to keep the iter from
pointing past the end of the map. How is this problem normally
solved?
|
by: netpurpose |
last post by:
I need to extract data from this table to find the lowest prices of
each product as of today. The product will be listed/grouped by the
name only, discarding the product code - I use SUBSTRING(ProductName,
1, CHARINDEX('(', ProductName)-2).
I can get this result, but I had to use several views (totally
inefficient). I think this can be done in one efficient/fast query,
but I can't think of one.
In the case that one query is not...
|
by: ratedr1 |
last post by:
I am currently trying to label rings (jewelry). They make specialized
tags (shaped like a butterfly, barbell, dumbell, etc) for this purpose,
the label goes through the ring, and then the ends stick together.
What I want to do is type information on these tags rather than write
on them, the only problem that I am having is that there is NO template
tht I can find anywhere for these labels. Now I have purchased the
labels and I have them...
|
by: Nikola |
last post by:
I need a function that reads from a txt file and randomly chooses a line
from which retrieves a string (with spaces) and returns it to main function.
thx
| |
by: sivashankar |
last post by:
hello experts
-can any one give me some module to do in asp.net
-if u give me the description i will give u with free of cost,since am new
now am in my final semester of MCA,just give me some time.
-Can any one give me some project to do
-If so i will be greatfull to u
Thanks In Advance
Siva
|
by: Noel |
last post by:
Hello,
I'm currently developing a web service that retrieves data from an employee
table. I would like to send and retrieve a custom employee class to/from the
webservice. I have currently coded the custom employee class and have built
it as a separate library (employee.dll). This employee.dll is being
referenced by both the web service and the windows application.
I face the following problem when I send this class to the webservice.
|
by: Bruno Alexandre |
last post by:
Hi guys,
I'm using a session to save an ArrayList, so I do not read Database
everytime user reload the page or enter the site (the Data is consistent for
all entire session time when the user is on the site).
I'm using a Class called ProductBoxes and inside I have a public property
of Object type and I call from the PageLoad event
dim boxes as new ProductBoxes
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |