Query to return last ten records

[danzweb]

Hi there,

This is the first time I have posted on a message board so please be gentle with me, thanks.

I have got the basics of Access but have come across a stumbling block, I have a very simple table showing

Staff Name
Date Assessed
Grade

I am trying to write a query to return the last ten records of a staff member.

I have the query to prompt me for the staff name, which works but returns all records for that member of staff.

Is there any way that I can ask the query to select the last ten records of that staff name by date descending.

Hope this makes sense, I have asked around at work but nobody knows how to do this.

Any help would be gratefully appreciated.

Dan

 

[Norie]

Open the SQL view of your query and substitute this, replacing Table2 with the name of your table.

SELECT TOP 10 Table2.[Staff Name], Table2.[Date Assessed]
FROM Table2
ORDER BY Table2.[Date Assessed] DESC;

Alternatively right click in the query design view and select Properties.

In the Top Values property field put 10, or whatever number you want.

 

[danzweb]

Bring it on!
That works fantastic.
Thank you very much for a speedy response.

Dan