Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Adding Dates


Message #1 by "James Potter" <questionaccess@h...> on Mon, 21 Oct 2002 10:14:47
I have two fields ID1 and ID2. ID1 is the default date (I have tried 
making it the system date by putting =Date() into the DefaultValue 
property. However when the form is run the field stays blank?). I need the 
value in the ID1 field (whether it be the default or user ammended value), 
to add the value in another integer field (DaysReq) to give ID2. 

However Sat and Sun are non working days. Only Mon-Fri should be included 
in the calculation. Inevitabley some coding is required, can anyone shed 
some light on the matter?

Thanks in advance
James  

  Return to Index