Datosortering og visning af sidste 5 faktureringsdatoer

You can use th efollowing syntax to get the newest five records. If more than 5 record have the same date then you will receive more than five!

SELECT TOP 5, .... ORDER By udskrivningsdato DESC

Just noticed that you have a UNIION in there!

You should maybe make a UNION query first, to get all the required information and then make another query based on the first to to format/group the result

Sorry ...

ORDER By udskrivningsdato DESC

giver ikke en tilfredsstillende sortering, og UNION kan ikke benyttes ifbm. SELECT TOP 5

... som du selv har erfaret ;)

is  it possible to send me your db so that I can see your data?

eksperten@NOSPAMsanthell.dk

remove NOSPAM

Det kan desværre ikke lade sig gøre ... indeholder forretningsfølsomme data ...

Men de to tabeller (tblData og tblDataIII) indeholder begge udskrivningsdato (egenskab dato/klokkeslet), genereret som Now() oprettelse af nye records.

Så kan du selv forsøge at oprette en db ... ;)

Is it not possible to send a copy of the tables so that they only contain the fields you use in the queries? and also the queries!
Yes I could make the tables myslef but I'm VERY lazy, and after all it is you who needs help :o)
It is also your data we need!

Sendt ... forespørgslen / dropdownboks ses i udskrivningsformularen

OK

I see what the problem is! Back soon

Takker ;)

OK!
I've made a query name (qryUNION)

SELECT Format$([udskrivningsdato],"dd"". ""mmmm yyyy") AS fakturadato, "1. Erindring" AS ID, Format([udskrivningsdato],"yyyymmdd") AS SortBy FROM tblData GROUP BY Format$([udskrivningsdato],"dd"". ""mmmm yyyy"), "1. Erindring", Format([udskrivningsdato],"yyyymmdd")  UNION SELECT Format$([udskrivningsdato],"dd"". ""mmmm yyyy") AS fakturadato, "2. Erindring" AS ID, Format([udskrivningsdato],"yyyymmdd") AS SortBy FROM tblDataIII GROUP BY Format$([udskrivningsdato],"dd"". ""mmmm yyyy"), "2. Erindring", Format([udskrivningsdato],"yyyymmdd");

Now the combo box's Row Source is changed to this

SELECT TOP 5 qryUNION.fakturadato, qryUNION.ID FROM qryUNION ORDER BY qryUNION.SortBy DESC;

Note: Because there is more than one record with the same date there are 6 records not 5!

Hi Terry

Sorry, but it´s not the answer I´m looking for. The query must return the latest 5 records forom both tblData and tblDataIII.

I can live with the sorting order ...

Hi Terry.

If you can't find a solution, it's ok.

For you effort, I still think you deserve the points ;)

I'll find a solution. I thought it was TOP 5 from ALL!
I'll get back as soon as possible

hopefully this gives you waht you want now.

(SELECT TOP 5 Format$([udskrivningsdato],"dd"". ""mmmm yyyy") AS fakturadato, "1. Erindring" AS ID, Format([udskrivningsdato],"yyyymmdd") AS SortBy
FROM tblData GROUP BY Format$([udskrivningsdato],"dd"". ""mmmm yyyy"), "1. Erindring", Format([udskrivningsdato],"yyyymmdd")
ORDER BY Format([udskrivningsdato],"yyyymmdd") DESC)

UNION (SELECT TOP 5 Format$([udskrivningsdato],"dd"". ""mmmm yyyy") AS fakturadato, "2. Erindring" AS ID, Format([udskrivningsdato],"yyyymmdd") AS SortBy
FROM tblDataIII GROUP BY Format$([udskrivningsdato],"dd"". ""mmmm yyyy"), "2. Erindring", Format([udskrivningsdato],"yyyymmdd")
ORDER BY Format([udskrivningsdato],"yyyymmdd") DESC);

Syntax error ORDER BY ....

Sorry, but it won´t work ... but don´t bother anymore, I can live with the solution I´ve alredy have ;) .... Thanks anyway ...

Yes I got the same error, thats why each select is in () then it works, or at least here :o)

Hi Terry ... it works, but the sorting order is no good ... :o(

I prefer the first solution

:o)