I have an Access query that I am using to append to another table.
I want to pull from a date field that would be the last date besides today ie. if there were 10 records accessed yesterday I want those to append to the new table not anything accessed today.
If the last time some recrods were accessed was 2 days ago i want those to append to the new table but not anythign from today.
Is this possible without typing in the date?