[thelist] SQL Distinct to 1 item

[Joshua Olson]

> -----Original Message-----
> From: j s
> Sent: Friday, June 17, 2005 12:16 PM
> 
> I got the sql statement to work but it's really slow. The 
> kind of slow where I'm getting gray hair slow.

Jess,

Have you considered, if it's possible, to move away from Access and move
into SQL Server?  There is a free version of SQL Server that is at least as
scalable as Access but gives you the benefit of the SQL Server engine, in
case you didn't know.

<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168 

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/