Vis den 1 af doubletter i tabel

Feks- således:

SELECT TOP 1 Tabel1.nr, Tabel1.felt1, Tabel1.tid
FROM Tabel1
ORDER BY Tabel1.nr DESC;

Kan du oversætte til ovenstående tabel?

Forstår ikke helt hvad du mener med Tabel1.nr?

Tabel1.Felt1 = EmpId?
Tabel1.tid = DataB?

Tabel1 = tblTraining
Tabel1.nr = ?

Det er blot mine objektnavne. Erstat Tabel1 med navnet på din tabel og feltnavnene med navnene på dine felter.
Brug evt. querybuilderen.

Tak det virker. Har dog lige et mindre problem

Form skal vise data fra 2 andre tabeller som har relation til tblTraining

tblEmploy (EmpId, Init, Fnavn, Lname osv)
tblJobs (JobId, title osv)

Hvordan kobler jeg de 2 på uden at de bliver sorteret med Top1? Men selvfølgelig bare henter de relavante data?

Min select ser sådan ud:
SELECT [tblEmploy].[EmpId] AS tblEmploy_EmpId, [tblEmploy].[Init], [tblJobs].[JobId] AS tblJobs_JobId, [tblJobs].[Title], [tblTraining].[TrainingId], [tblTraining].[EmpId] AS tblTraining_EmpId, [tblTraining].[JobId] AS tblTraining_JobId, [tblTraining].[DateB], [tblTraining].[DateE], [tblTraining].[Approval], [tblTraining].[TrainedBy] FROM tblJobs INNER JOIN (tblEmploy INNER JOIN tblTraining ON [tblEmploy].[EmpId]

Not quite sure what your after.

kun vise den nyeste (ud fra DatoB)

The two lines you are indicating have the same datoB!

Are you saying that you only want to see the one with the highest TrainingId?

If so, then do this
Make a query where you Groupp on EmpId and DateB and choose Max for Training Id. Don't select any other fields.

Now save the query.

Now make another query where you select all of the fields from the query you just made. Add the table to the query again and make a join on TrainingId between the first query and the table.
Now select the remaining fields from the table.

Hope you understand that.

Forget my answer, hadn't seen all of the comments ...

But I still don't understand what your after :-)

As far as I can make out mugs query will only return one record ...

Mugs gav mig dette:
SELECT TOP 1 tblTraining.EmpId, tblTraining.JobId, tblTraining.DateB FROM tblTraining ORDER BY tblTraining.DateB DESC;

Og det virker i min form. Men jeg skal bruge data fra 2 andre tabeller som tblTraining har relation til, og jeg ved ikke hvordan jeg kobler det på ovenstående.

Det vil sige at jeg skal have denne her funktion:
SELECT TOP 1 tblTraining.EmpId, tblTraining.JobId, tblTraining.DateB FROM tblTraining ORDER BY tblTraining.DateB DESC;

sat ind i denne her:
SELECT [tblEmploy].[EmpId] AS tblEmploy_EmpId, [tblEmploy].[Init], [tblJobs].[JobId] AS tblJobs_JobId, [tblJobs].[Title], [tblTraining].[TrainingId], [tblTraining].[EmpId] AS tblTraining_EmpId, [tblTraining].[JobId] AS tblTraining_JobId, [tblTraining].[DateB], [tblTraining].[DateE], [tblTraining].[Approval], [tblTraining].[TrainedBy] FROM tblJobs INNER JOIN (tblEmploy INNER JOIN tblTraining ON [tblEmploy].[EmpId]

Jeg har forøvrigt en Query på den form. Kan man ikke benytte et eller andet under "criteria"-felterne i min query?

Oprettter nyt spm.

Mugs, din løsning var rigtig til det oprindelige spm. Smid svar. :)