Recent content by leepem

in the end it was: =IIf(IsNull([EndDate]),DateDiff("d",[StartDate],[Text23]),DateDiff("d",[StartDate],[EndDate])) thanks for your help

I have the following formula entered in a text box on a report =DateDiff("d",[StartDate],[EndDate]) however if there is no EndDate then i need it to calculate the StartDate (N.B. there will always be a StartDate) from todays date in the same text box. Can anyone please help!!! thanks

thanks, have sussed it out now!!!

I need to create a command button that simply, when pressed places todays Date into a text box, the text box should have no value in untill the command button is pressed. Thanks in advance for any help i receive Lee Pemberton

Hi, i have a database and i need to create a report which does the following: i have three main tables: Directors - with directors names in MeetingTypes - with names of meetings in Minutes - This is where the data is stored, data is entered via a form and the Director and MeetingType is...