Re: maxrecords property doesn't work for me

Thanks for the help. I just implemented your SQL statement and tested it.
It works great. I don't know SQL very well, so I tried implementing the
solution with code before asking for help. Your solution is quite
elegant.

You want to bone up on SQL.
In general if there is a choice of doing a task

(i) with one or two lines of SQL
(ii) using a single or multiple Recordsets and some VB/C++/etc glue code

then option (i) is the best and fastest. Make the database engine work for
you.

I only do (ii) if (i) for some reason cannot be done.

Stephen





.

Relevant Pages

  • dlookup and sql
    ... creates a temp query using sql, then using dlookup to get data, eg. using sql ... using dlookup to return the count. ... Dim qry As QueryDef ... Is there a more elegant way to pass the result from a sql statement straight ...
    (microsoft.public.access.queries)
  • Re: [Info-Ingres] Formatting dates on insert or update - Helprequired please
    ... Dave's solutions was perhaps the more elegant and simpler. ... Formatting dates on insert or update - ... Hope you've got your Jandals on for this one... ... Why not use the simple method of SQL, here are two examples for DD- ...
    (comp.databases.ingres)
  • Re: Berechnete Felder archivieren
    ... >> Musst du per SQL oder per Recordset machen. ... "Elegant" ist ein bissel Geschmacksfrage. ... SQL = Schnelle Qualitäts-Lösung ...
    (microsoft.public.de.access)
  • RE: Backups have Shadow Copy Problems
    ... Active backup destination: File ... Reason: The process cannot access the file because it is being used by ... Warning: Unable to open "C:\Documents and Settings\Administrator\Local ... Warning: Unable to open "C:\Program Files\Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... recovery model of the SQL Server database to Simple. ... Warning: Unable to open "C:\Program Files\Microsoft SQL ... Reason: The process cannot access the file because it is being used by ... Backup completed on 2/14/2006 at 3:39 PM. ...
    (microsoft.public.windows.server.sbs)