Access Question, How can I get rid of transactions that occured before a certain date, but not get rid of?

null values.





In other words I want to keep the data that occured after a certain date and the null values as well.|||Use a query as record source for any form that you are using





Add a criteria to the date field that eliminates any records older then three months from the query's recordset:





DateDiff("m",[Datefield],Date()) %26gt; 3





The older records will still exist in your table, but will not be visible.





If, instead of three months ago, or whatever, you want a fixed date, then use





%26gt; #04/23/2006#





for records that are more recent than 4/23/06|||put


expx:IsNull([column_name_of_the_column鈥?br>

in the field part of the query


and


%26lt;%26gt;False


in the OR critera part








the end of this line


expx:IsNull([column_name_of_the_column鈥?br>

is squarebracket roundbracket


I don't know why the editor cuts it off








The sql is going to look like this





DELETE TOAT_from_SS.GMEDate1, IsNull([TOAT_from_SS].[GMEDATE1]) AS Expr2, *


FROM TOAT_from_SS


WHERE (((TOAT_from_SS.GMEDate1)%26gt;#12/22/2004#)) OR (((IsNull([TOAT_from_SS].[GMEDATE1]))%26lt;%26gt;F鈥?br>




crap, this editor cut off everything.


Frustrated.....








Do you need to know how to set up the query to 'delete' everything lower than a certain date as well or is it just the Nulls part you need help on?