FYI, I tracked down the problem I was having yesterday. My original query selected a column Last_Disb_Date. This is defined in the database as a date column. I changed it to
Select ... RTrim(Last_Disb_date) As Last_Disb_Date .... and the query now works! Don't know why, since this workaround wasn't necessary in another report that selected the same column from the same table in the same database, but only had a slightly different WHERE criteria. Antony ---------------------------------------------------------------------- Maddocks Melbourne - Tel: (61 3) 9288 0555 Fax: (61 3) 9288 0666 Sydney - Tel: (61 2) 8223 4100 Fax: (61 2) 9221 0872 Web: http://www.maddocks.com.au ---------------------------------------------------------------------- The information in this electronic mail is privileged and confidential, intended only for use of the individual or entity named. If you are not the intended recipient, any dissemination, copying or use of the information is strictly prohibited. If you have received this transmission in error please delete it immediately from your system and inform us by email on [EMAIL PROTECTED] ---------------------------------------------------------------------- --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
