Kommandoen LIMIT

SELECT TOP 5, * FROM TELEFONBOG

ORDER BY etellerandet LIMIT 0,5 burde virke...

SELECT TOP 5 * FROM TELEFONBOG

LIMIT in Access?

Mange tak Terry DET VIRKER PERFEKT !

..og til el_barto, jeg kan ikke få limit til at virke !

Hvilket som Terry siger nok skyldes at LIMIT ikke eksisterer i Access.

*LOL* Jeg sover vist :)

:o)

NEJ VENT....DET HENTER ALT ???

?

SELECT TOP 5 * FROM TELEFONBOG virker ikke ?????

Den henter alle posterne ?

Try this!
Make a new query WITHOUT writing TOP 5. Then in the query properies enter 5 in the Top Values property. This is actually the same as entering TOP 5 in SQL. But I cant see why ALL records shoul be returned!
TOP n actually CAN return MORE than what you ask for. For example if you used order by SALARY and there were more than 5 with the same salary then ALL of those would be returned. Try using order by on one of the fields!