Display 5 last records on a main menu

[BSJoJaMAx4]

Hi - just wondering, as well as menu items is it possible to show the last 5 items entered into the database on the main screen?

[Homegrownandy]

Make a Query and display the results in a sub form on the main page. Take a look at these:

http://stackoverflow.com/questions/8...than-5-results
http://stackoverflow.com/questions/9...n-access-query
http://www.allinterview.com/showansw...mn-salary.html

Andy

[ranman256]

last 5 is relative....
sort in reverse and query the top 5
or
query on the last 5 indexes

[orange]

Tell us about the records being saved. Is there a date/time stamp? There is no inherent Order to records in a table. If you want an Ordered list, you will need a field that represents "whatever LAST means to you", then use a query with an Order By.

[Homegrownandy]

If the primary key is an auto number you can just use that to find the latest I was thinking.

[orange]

More about autonumbers

[BSJoJaMAx4]

Hi all - thanks so much for your help. I got it to work by creating a new form, adding it as a sub form to the main menu, and tinkering with the sort order (by ID - autonumber) and limiting to number of records displayed.

[BSJoJaMAx4]

One other question. I have a table called exiting staff data and a field called Follow up required. I want to count the number of Yes entries and display it on the main menu. Have tried all sorts of permutations but keep getting error messages. Any thoughts?

[Homegrownandy]

Hey, sorry for the late reply,

http://stackoverflow.com/questions/1...a-form-control

you need a query to gather the 'yes' records then just count them and display in a text box.

I'm guessing you solved this issue by now though.