Query to list only 50 latest records???

[Joe M]

Hi, how do I create a query to list only the last 50 latest records of a
table????

 

[fredg]

Hi, how do I create a query to list only the last 50 latest records of a
table????

Create a Top 50 query and sort on the date field (or whatever field
determines what is latest or oldest) descending.

Create a regular Select Query, then click on the Top Values tool
button (it probably says "All" at the present time) and enter the
value.

SELECT TOP 50 TableName.*, TableName.DateField
FROM TableName
ORDER BY TableName.DateField DESC;

 

[Joe M]

Thanks Fredg,
It works, now I can list only the 50 latest records.
But now I also need the 50 records to be sort aphabetically using the Name
field, how do I get it to sort aphabetically?? Thanks.