Hi list, why won't this work? SELECT * FROM calls WHERE call_for='Paul' AND call_date=#8/11/2003# ORDER BY calls.call_for, calls.call_time DESC;
Also try DateDiff("d",call_date,#8/11/2003#)=0 in case you have a date and time in there.
Regards, David
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
