Showing x highest records

[RonnieODIN]

Hi,

I am making a DB which contains info of some components in machines I have. For instance I have info about the IP adress for the component. The info is filtered on machine and component but I would also like to display only the 3 newest updates for the component. The ID will not be consecutive.

Is it possible to obtain this somehow?

I am new to access and have no idea how to do this.

Thanks in advance.

 

[John Big Booty]

See this link on how to Return the top n Results.

 

[RonnieODIN]

Thanks. Really can't believe it was that simple.