Scott Marcus
marcus at tsstech.com
Mon Mar 28 12:33:42 CST 2005
Did you check your references on the users machine vs. your machine? Scott Marcus TSS Technologies, Inc. marcus at tsstech.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of connie.kamrowski at agric.nsw.gov.au Sent: Saturday, March 26, 2005 11:30 PM To: accessd at databaseadvisors.com Subject: [AccessD] Trouble with SQL statement on two different machines(sans typo) Further to my previous post I have ascertained that it is actually having trouble with the Max(Right([AuthorityNumber],5)) AS [Number] Connie Kamrowski Analyst/Programmer Information Technology NSW Department of Primary Industries Orange Ph: 02 6391 3250 Fax:02 6391 3290 This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient or received it in error, please delete the message and notify sender. Views expressed are those of the individual sender and are not necessarily the views of their organisation. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com