R
Roger Shugrue
I really would appreciate help on this one!!. In a 97 mdb I used two entered
dates on a form to calculate a third date(on the form in a hidden field).
This was a date when a course was completed and the date when the course was
done for the second time. The third calculated date is when the next course
is due and is conditional on the first 2 dates.
I then saved the result to the table by simply making another field = to
this result. The calculated date was then saved to the table with the first
two dates. I am now upgrading to 2002 project linked to SQL server and would
like to solve this in the easiest way possible VB or otherwise. Could
someone help me with a solution for this problem as I cant make it work the
way it used to in 97??? Thanks in advance
Roger
dates on a form to calculate a third date(on the form in a hidden field).
This was a date when a course was completed and the date when the course was
done for the second time. The third calculated date is when the next course
is due and is conditional on the first 2 dates.
I then saved the result to the table by simply making another field = to
this result. The calculated date was then saved to the table with the first
two dates. I am now upgrading to 2002 project linked to SQL server and would
like to solve this in the easiest way possible VB or otherwise. Could
someone help me with a solution for this problem as I cant make it work the
way it used to in 97??? Thanks in advance
Roger