Calculate days between two dates by VBA

[June7]

You can but why run risk of the saved calculated value getting 'out of sync' with the raw data?

[Bob Fitz]

I save calculated data in textbox, I still think it would be good if I could save the calculated data in table.....

Well, we can only give you what we consider to be our best advice. At the end of the day it's your db and your decision. I wish you good luck with your project. I fear you may need it.