 <p>Provided that <code>PreCalcCurrentMonth</code> is a Date variable, try something like this (untested): </p> <pre><code>mySQL = "DELETE * FROM [tblBillingData]" &amp; _ "WHERE (((tblBillingData.[Billing Month]) &gt; " &amp; _ Format(PreCalcCurrentMonth,"\#mm\/dd\/yyyy\#") &amp; _ "));" DoCmd.RunSQL mySQL </code></pre> <p><code>Format(PreCalcCurrentMonth,"\#mm\/dd\/yyyy\#")</code> ensures that your date is converted to a string in US date format #mm/dd/yyyy#, whatever your regional settings. # is the date separator.</p>