Re: HELP: Retrieving 5 most recent records by date...

This works, but SQL will select the top 5 dates, not records so if have more than one record with the same date, you could get more than just 5 records returned. If you have unique dates it won't be a problem, but otherwise you may still have to toss the results into an array (although it will be

RE: HELP: Retrieving 5 most recent records by date...

Don't you need to add the DESC argument to the order by to achieve the desired results? Dan -Original Message- From: Chris Chambers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 18, 2000 9:52 PM To: [EMAIL PROTECTED] Subject: RE: HELP: Retrieving 5 most recent records by

RE: HELP: Retrieving 5 most recent records by date...

lto:[EMAIL PROTECTED]] Sent: Tuesday, April 18, 2000 7:52 PM To: [EMAIL PROTECTED] Subject: RE: HELP: Retrieving 5 most recent records by date... -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 SELECT TOP 5 field FROMtablename ORDER BYdatefield __

RE: HELP: Retrieving 5 most recent records by date...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 SELECT TOP 5 field FROMtablename ORDER BYdatefield _ Chris Chambers ICQ: 40311211 AIM: CTC HOME VOX: 757-896-6393 FAX: 757-896-0774 _ - -Original Me