Kriterier i Query

I am not quite sure it is what your trying to do?

Try giving an example so I can maybe see what your doing

Which tables/fields do you have and which fields are the primary/foreign keys?

If you make a query with the two tables then if they are related and you have set the primary and foreign keys up correctly you should see a thin line joining the primary key from one table with the foreign key in the other table.
If you now right click on this thin line you should have three possibilities, choose the one which suits your needs. Now when you run the query you will also see records on the primary key side even when the foreign key side is empty.

mrs>We can not help if you do not comment!

Table one:
ID Overskrift Url Dato

Table two:
BillederID Kommentar

Link from ID to BillederID with option on right-click at the thin line.

Its the Kommentar that want to set criteria for.
If ID = BillederID then Top 1
else
is Null then write ID without anything in Kommentar

Sort of like that.

make a query. If there is NOT a thin line between ID and BillederID then drag ID (with the mouse) over to BilledID. You should now have a thin line (JOIN) between the two tables.

Now in the sort field for the ID field choose DESC (Descending)

Now right click in the are where the tables are and choose properties from the menu.
In the properties you will see a field (Top Values) it will be = All change this to 1. This is the same as TOP 1 for the newest ID

you can send the dB to eksperten@santhell.dk if you dont understand what I mean. But I think you should try it.

Not excatly that.
It have to be top 1 from each ID.
In table two you can write more than one record to combines with ID i table one.
So all ID's fra table one and top 1 from table two that ID equals BillederID

Ill look at it again tomorrow.

SELECT tblOne.ID, tblOne.Overskrift, tblOne.URL, tblOne.Dato, First(tblTwo.Kommentar) AS TopKommentar
FROM tblOne LEFT JOIN tblTwo ON tblOne.ID = tblTwo.BilledID
GROUP BY tblOne.ID, tblOne.Overskrift, tblOne.URL, tblOne.Dato;

This only gives you the first of each comment, if you want the TOP then you will have to sort the kommentar field in which ever order you want but I cant see what use that is.

see at www.ramsoe-usk.dk/oversigtbilleder.asp
I only wants the newest comment under the picture.

Whats wrong here?

Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT Billeder.ID, Billeder.Overskrift, Billeder.URL, Billeder.Dato, First(Billederindlaeg.Kommentar) AS TopKommentar FROM Billeder LEFT JOIN Billederindlaeg ON Billeder.ID = Billederindlaeg.BilledID GROUP BY Billeder.ID, Billeder.Overskrift, Billeder.URL, Billeder.Dato"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("database/Billeder.mdb")
rs.Open strSQL, strDSN, 1, 3

1 was expected in the lowest line.

I have NO idea what the fields contain so I cant say. If you run the query in Access query designer you will see EXACTLY what it is finding. Then you have some ide as to what is wrong. IF there is only one record in Billeder and zero, one or more records in Billederindlaeg then the query SHOULD give you what you want, but as I said I cant see what you have!

What does this mean?

1 was expected in the lowest line.

The link www.ramsoe-usk.dk/oversigtbilleder.asp doesnt tell me much at all, as far as I can see there IS only one comment under each picture!

Tilføj en forespørgsel med alle de mulige ID-numre og klik
på Vis/Totaler og vælg Maks. Hvis nyeste ID-nummer altid ligger sidst
i tabellen kan du også vælge Sidste.

Tak for hjælpen Terry.

Svaret er blevet sendt pr. mail

better place the solution here, and thanks mrs :o)

A query (qryCommnt) for selecting the comments in the correct order. and as Kommentar is a memo field I have to select only the first 255 characters (text field).

SELECT Billederindlaeg.ID, Billederindlaeg.BillederID, Left([Kommentar],255) AS comment
FROM Billederindlaeg
ORDER BY Billederindlaeg.ID DESC;

and now the query putting it all together.

SELECT Billeder.ID, Billeder.Overskrift, Billeder.Url, Billeder.Dato, (SELECT TOP 1, comment
FROM qryComment WHERE qryComment.BillederID = [Billeder]![ID]) AS Comment
FROM Billeder;

I'm sure it could be put into one SQL but I find this easier.