> removed the WHERE 1=1 but know luck.. It will error without SOME type of WHERE clause.. WHERE 1=1 should work in access.
Is the DateAdd function supported in Access?? Cheers, Adam -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 19 March 2003 3:23 PM To: CFAussie Mailing List Subject: [cfaussie] Re: look up date by years old with a 2 year spread < 2 > 2 Hi steve removed the WHERE 1=1 but know luck.. should i change the AND dob BETWEEN DateAdd(Year,#Form.OlderThan#,dob) AND DateAdd(Year,#Form.YoungerThan#,dob) move the hashes around the dob as well? [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. SQL = "SELECT Talent.talentID , Talent.Name , Talent.Gender , Talent.DOB , Talent.Hair , Talent.Eye , Talent.Height , Talent.Clothssize , Talent.shoesize , Talent.hobbies , Talent.BIO , Talent.Compcard , Talent.ID FROM Talent AND Talent.gender = 'male' AND dob BETWEEN DateAdd(Year,5,dob) AND DateAdd(Year,1,dob)" --- 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/
