need help to advance db

[Greier Matthias]

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.Lehrkraft, (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

[MGFoster]

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.Lehrkraft, (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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnaGM4echKqOuFEgEQJHYwCbBfGXtSsz3trOTPcvCT+wkI 7yNTwAn1lC
o1BKFIbJhzBPFp/HD8AS3HMd
=uIZv
-----END PGP SIGNATURE-----

[Greier Matthias]

MGFoster <[e-mail]> wrote in
news:MC*****************@newsread1.news.pas.earthl ink.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