Nik I don't think you are doing it the right way or perhaps I don't understand what you want to achieve. If A and B are dates how can C (A-B) be a date? A-B should give you number of days, months or years between the two dates. In that case you would use the DateDiff function.
Regards Liveson ----- Original Message ----- From: nikita.malhotras To: [email protected] Sent: Saturday, 26 January, 2008 12:08 AM Subject: [ms_access] Help on Calculation Hi Friends, I have three columns A, B & C (Date Data Type) containing Dates in following formats: 1/14/2008 10:45 AM above format is for all three above columns within a table. 1. Now I wish to contain C = A - B. I mean substraction of A & B in to C. While doing so through programming (VBA), I am getting wrong results in A. Please help me if how I can do so and I need urget relpy on the same. Procedure that I am following is quite simple through VBAL: C.Value = A. Value - B.Value I am writing this code in VBA for form to update values in Table. However, results are correct. => The result should also be in 1/14/2008 08:12 AM format. Looking forward for your reply at [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> . I shall be highly thankful to you. Regards, Nik. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
