I am getting an error when trying to display records before a certain date in my "expiry" column which is defaulted 7 days from the current day.<BR><BR>SQLtemp = "SELECT * FROM eboard WHERE department = &#039;" & department & "&#039; AND category = &#039;" & category & "&#039; AND ((Expiry()&#060;CDate(Date))) ORDER BY whensent"<BR><BR>The error:<BR><BR>[TCX][MyODBC]You have an error in your SQL syntax near &#039;()&#060;CDate(Date))) ORDER BY whensent&#039; at line 1 <BR><BR>This worked fine under access, but not with mySQL - can anyone help please????<BR>Thanks<BR>Terry