On one of my pages I have edited the SQL Query at Step 4 to add several time fields like this:
Field1+Field2+Field3+Field4+Field6 as Field9,
this works fine because I don't really need the total until all the other fields are completed but if my next field is:
Field1+Field2+Field3+Field4+Field6+Field7 as Field10,
This again works fine, as long as there is an entry in Field7. If there is no entry in that field it just leaves Field10 blank.
Is there a way of saying +Field7 or +00:00:00?
Bob
APSRunnerPro Build225