I have a simple table with a date field.
I want to be able to extract the records that are newer than a date that I will input.
This date would be different each time but the range would always be the same , eg 6 days
The record set changes so it is not a fixed point in time.
To summarise, need a query that asks for a date to be input, and then returns any records with a date greater than the input date minus 6 days.
Thanks