Check For Records From Date Every 7 Days

[burrina]

Care to show me how this could work? Attached is my table of missed transactions. I would want to see all dates every 7 days using PeriodTypeID = "ww"
Starting date would be dteentered and end date would be today and date criteria would be PeriodTypeID wher it was "ww" which means weekly.

[qa12dx]

hi, the table u'd attached didn't ve any data. i put some dates in there in the dteentered field. if u scroll using next button on the form that opens on load, u'll see the dates every 7 days below.

if u choose to enter a new date in dteentered then the results below aren't showing properly, i have to check what problem with requery is. if u go back a record and come back it shows true dates.

but i think u already have a data set that u would like to see the dates every 7 days till date, so i just left it as is.

i haven't explained how i did it 'cause i think u know how to look it up...

hope it was of some use to u.

cheers

[burrina]

Thanks, I will see if I can adapt and make that work. Sorry for the no data, I did not check before sending, doing so much beta testing!

[burrina]

nope, too many variables in play. Maybe I can use on just one of them! Thanks for your hard work!