> I noticed that the SQL syntax was from MySQL-- > would it be different for Access2000?
yes that's the nice thing about standards, there's so many to choose from with regard to dates, sql syntax is different in almost every database for example, a database may implement the sql standard INTERVAL data type and allow its use in sql syntax -- or not ms access has a similar function to mysql's -- DateAdd not sure the access WHERE clause has that same neat trick about turning a 0 into false, though, so you should use the access IIF() function instead rudy - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "rudy" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
