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/
h
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
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: [EMA
3 matches
Mail list logo