Select last 15 records 2

[ZOR]

The code below is the record source of a listbox. How do I modify the code so that it shows only the last 15 records
in ID2 order. Many thanks

SELECT TXMASTERS.ID1, TXCLIPS.ID2, " " AS Persons, TXCLIPS.NName AS Name, TXCLIPS.Comments, TXCLIPS.Start AS [Time In], TXCLIPS.End AS [Time Out], TXCLIPS.ID1
FROM TXMASTERS INNER JOIN TXCLIPS ON TXMASTERS.ID1 = TXCLIPS.ID1
WHERE (((TXCLIPS.ID1)=[FORMS]![Mainform1].[FORM].[ID1]))
ORDER BY TXCLIPS.ID2 DESC;

 

[r937]

SELECT [blue]TOP 15[/blue] TXMASTERS.ID1 ...
FROM ...
WHERE ...
ORDER BY TXCLIPS.ID2 DESC;


r937.com | rudy.ca

 

[ZOR]

Many thanks, however its the last 15 records I am trying to get? Thanks

 

[eerlee]

hi

Do you need the last 15 records ordered by TXCLIPS.ID2 DESC?
If so, then order it by ASC then get the top 15.

SELECT *
FROM
(
SELECT TOP 15 TXMASTERS.ID1, TXCLIPS.ID2, " " AS Persons, TXCLIPS.NName AS Name, TXCLIPS.Comments, TXCLIPS.Start AS [Time In], TXCLIPS.End AS [Time Out], TXCLIPS.ID1
FROM TXMASTERS INNER JOIN TXCLIPS ON TXMASTERS.ID1 = TXCLIPS.ID1
WHERE (((TXCLIPS.ID1)=[FORMS]![Mainform1].[FORM].[ID1]))
ORDER BY TXCLIPS.ID2 ASC
) T
ORDER BY ID2 DESC

 

[ZOR]

Mnay thanks, that sorted that out. Have a good Easter, regards