J jgipe307 Registered User. Local time Today, 10:53 Joined May 16, 2010 Messages 11 Dec 5, 2010 #1 the reports are show #error on it. If the field is blank i dont need it in the report. If someone could tell me how to solve this problem i would appreciate it. Thank you Attachments tracker.zip tracker.zip 175.5 KB · Views: 96
the reports are show #error on it. If the field is blank i dont need it in the report. If someone could tell me how to solve this problem i would appreciate it. Thank you
DCrake Remembered Local time Today, 17:53 Joined Jun 8, 2005 Messages 8,626 Dec 5, 2010 #2 You are not testing if the date you are wanting to work with actually exists. Use an IIF(...,True,False) statement. Also why not use DateAdd() instead of DateSerial? =IIF(IsDate([M-4]),DateAdd("M",4,[M-4))
You are not testing if the date you are wanting to work with actually exists. Use an IIF(...,True,False) statement. Also why not use DateAdd() instead of DateSerial? =IIF(IsDate([M-4]),DateAdd("M",4,[M-4))
