Limiting in queries

[jaanisf]

In MySQL:

SELECT something1,something2 from somebase WHERE this=that LIMIT 0,5 ORDER BY something1 DESC;

How can I limit query in Access queries? I need just the last 5 records to show, for example.

Thanks in advance!

 

[jrbarnett]

With Access/Jet you can SELECT TOP x to retrieve the first x records of a dataset, but it doesn't support the LIMIT feature of MySQL (not a product I know a lot about unfortunately).

To retrieve only a certain number of records the easiest way is to use a recordset object in VBA and pick out the last 5 records (or any other number).

John

 

[jaanisf]

Well, you could maybe kindly tell me exactly, how can I do it in VBA, since I'm just a beginner in Access.
And.. the thing is - I have a subform, lets call it Sub1 in a form, for example Form1. Sub 1 is on tabular mode, and I want it to show me the last 5 records in following order: the latest record on top and the oldest below. I need it just because I use the Form1 to add new records, and sometimes I get disturbed in my work, so, when I come back, I want to see the latest records I've done, so that I could know without pressing any buttons where to continue my work. Hope you understand and can help

 

[WildHare]

Don't do it in VBA - do it in the query.

In the query for the subform, set the date guy to sorted in DESCending order, and do a TOP 5. It should return the 5 most recent records...

Jim

Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare.htm