Anyone know how to replace the DFIRST statement in Access to working in/with
SQL. SQL Server does not have an equavalent statement/function.

John Cosmas

You could use a subquery:
(SELECT TOP 1 YourField FROM tblYourTable ORDER BY OtherField)

--
Duane Hookom
MS Access MVP


"John Cosmas" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Anyone know how to replace the DFIRST statement in Access to working
in/with
> SQL. SQL Server does not have an equavalent statement/function.
>
> John Cosmas
>
>

"John Cosmas" <(E-Mail Removed)> wrote in
news:#(E-Mail Removed):

> Anyone know how to replace the DFIRST statement in Access to working
> in/with SQL.

What on earth use is DFirst if you can't specify a sort order? It's not
going to be truly random, and it's not going to be specific either.

Any guesses?

Tim F

On Mon, 19 Apr 2004 11:40:17 -0700, Tim Ferguson
<(E-Mail Removed)> wrote:

>"John Cosmas" <(E-Mail Removed)> wrote in
>news:#(E-Mail Removed):
>
>> Anyone know how to replace the DFIRST statement in Access to working
>> in/with SQL.
>
>What on earth use is DFirst if you can't specify a sort order? It's not
>going to be truly random, and it's not going to be specific either.

It's only useful if you don't CARE which record you get. This can
happen; a join query might have only one record on the main table for
instance. In practice I rarely use it, and never under any
circumstances use DLast - it has the same problems and requires that
Access populate the entire recordset rather than just pulling the
first record.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

John Vinson <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in
news:(E-Mail Removed):

>>What on earth use is DFirst if you can't specify a sort order? It's not
>>going to be truly random, and it's not going to be specific either.
>
> It's only useful if you don't CARE which record you get. This can
> happen; a join query might have only one record on the main table for
> instance.

.... so wouldn't that be a normal DLookUp() function?


To be honest, I never even knew the functions existed, and even the help
file admits they return the value from a random record. Inexplicable.

B Wishes


Tim F