I need to put a label in my access application that simply shows me the date for the following Sunday. For example if today is Friday 3rd then it would show that the next date of the next sunday is 5th. But when we get to Monday 6th I need that label to automatically show the following sunday which would be the 12th and so fourth. Basically I have a rent charging application and the charges are calculated weekly on a sunday, and I need the label to show the next charge date
Any help would be greatly appreciated.