Hi I'm new to these forums and not the greatest on Access so any help is muchly appreciated.
Basically I have a form with the fields 'RenewalDate' and 'DaysRemaining'. At the moment I have this in the control source of my 'DaysRemaining' field...
DateDiff("d",Now(),[RenewalDate])
However...