I have a button which adds a filter based on the more recent translactions. The user fills in the number of days and only the records since then show. The problem is if the user changes his mind and enters another number of days the filter is added to the previous one rather than replacing it.
What would be the best way to replace the Where clause below?
strWhere = strWhere & "RecentActivity >= #" & date & "#-" & strDays