Select only one (most recent) record

[Van T. Dinh]

See the techniques in The Access Web article:

<http://www.mvps.org/access/queries/qry0020.htm>

HTH
Van T. Dinh
MVP (Access)

 

[George Avery]

On Sun, 31 Aug 2003 19:04:40 -0700, "Van T. Dinh"

[snip]

Thanks - I'd already looked at Dev Ashish' site but didn't find that.
I really get stuck when it comes to anything involving sql stuff but
once again you've rescued me ;^)
GA