difference betwwn dates

[binbyte]

I have got a textbox in a form where I put the number of days between two different dates but I don't know how update the field in the table to show the number of days in the table too. I hope anyone help me.

Thanks

 

[jgoodman00]

I assume you are using DATEDIFF to calculate the number of days. If this value is then written to a textbox control & the control is bound to your underlying table, when you navigate records it should save the value. You could manually save the record using

DoCmd.RunCommand acCmdSaveRecord

James Goodman MCSE, MCDBA

http://www.j.goodman.dsl.pipex.com

 

[binbyte]

thanks for your help

 

[JeremyNYC]

But don't. If you're storing the two dates, don't store the number of days between them. You can always do this calculation on the fly. Storing all three values is asking for problems--your data will end up being out of synch sooner or later.

---
Jeremy Wallace
METRIX Project Coordinator
Fund for the City of New York