RE: It WAS working I tell you...

2002-10-23 Thread Mosh Teitelbaum
Access sometimes returns this error message if you make reference to an object (table, column, etc.) that does not exist or is not identified in the query. Is it possible that you misspelled one of the column names? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email:

RE: It WAS working I tell you...

2002-10-23 Thread Tilbrook, Peter
Nope. All correct. Was working fine and then stopped. Is working under SQL Server 2000 just fine. -Original Message- From: Mosh Teitelbaum [mailto:mosh.teitelbaum;evoch.com] Sent: Thursday, 24 October 2002 10:21 AM To: CF-Talk Subject: RE: It WAS working I tell you... Access sometimes

RE: It WAS working I tell you...

2002-10-23 Thread UXB Internet
Try eliminating the ASC in the order by clause. Access orders ascending by default. Use: ORDER BY CategoryName Instead of ORDER BY CategoryName ASC Best regards, Dennis Powers UXB Internet - A Web Design and Hosting Company tel: (203)879-2844 fax: (203)879-6254 http://www.uxbinternet.com/