I'm not that familiar with MS Access's fake queries... But I'm assuming that 'First' returns the top record?
MS SQL:
SELECT TOP 1 * FROM ...
mySQL
SELECT * FROM ... LIMIT 1
Mark Hensler
If there is no answer on Google, then there is no question.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.
Mark Hensler posted this at 21:18 — 25th February 2003.
He has: 4,048 posts
Joined: Aug 2000
I'm not that familiar with MS Access's fake queries... But I'm assuming that 'First' returns the top record?
MS SQL:
SELECT TOP 1 * FROM ...
mySQL
SELECT * FROM ... LIMIT 1
Mark Hensler
If there is no answer on Google, then there is no question.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.