	AllExperts > Using MS Access
	Search

About Richard Rost
Expertise

I am happy to answer any kinds of questions about Microsoft Access - from basic table design to advanced VBA programming. Also, please feel free to check the Access Tips & Tricks section of my web site.

Experience
I am the president of AccessLearningZone.com and 599CD.com. I specialize in Microsoft Access Tutorials. I have been teaching Access in the classroom since 1994, and online since 2002.

Education/Credentials
I am a self-taught Access expert. I have been building databases for clients since the early 90s. You can see a sample of my Access Tutorials on my web site at 599CD.com

You are here: Experts > Computing/Technology > Business Software > Using MS Access > Days Elapsed between Dates

Using MS Access - Days Elapsed between Dates

Expert: Richard Rost - 10/16/2009

Question
Hi

I’m a beginner with Access.
Basically I need to add a control in my form which will show the days elapsed between two dates.
Many thanks for your help.
Raz

Answer
That's a simple calculated field.

If you have D1 and D2 and want the difference between them, make a new UNBOUND Text Box (not tied to a table field) and set the Control Source to:

=D2-D1

Or, you could also do this as a calculated query field if you need to have this value anywhere else (in reports, for example). See:

It sounds to me like you just need to learn how to properly create CALCULATED QUERY FIELDS. You can make a query that will perform math operations for you automatically.

Please see the following FREE video tutorial on my web site for step-by-step instructions on how to create calculated query fields:

http://599cd.com/tips/access/calculated-query-fields?key=AllExperts

Let me know if you have any other questions or comments.

Also, be sure to visit my web site and watch my FREE 90-minute MICROSOFT ACCESS VIDEO TUTORIAL. Go to http://www.599cd.com/Access/AllExperts

Cordially,

Richard Rost
599CD Computer Training
http://www.599cd.com

P.S. Also, don't forget to visit my FREE Microsoft Access Tips & Tricks Page at http://www.599cd.com/Tips/AllExperts

P.P.S. I volunteer my time at AllExperts to help people, and I get a LOT of questions, so I can't take an hour to answer each question. If you need more DETAILED HELP, come to my TechHelp web site at http://www.599cd.com/TechHelp/AllExperts and I'll take as much time as you need to answer your question.

http://www.599cd.com/Microsoft_Access_Tutorial?key=AllExperts

I hope this information helps to solve your problem. If there is ANY REASON why you won't give me a RATING of 10 please let me know so I can improve upon my answers in the future. Thank you!

Sign up for my FREE NEWSLETTER with lots of TIPS and TRICKS. Visit http://www.599cd.com/MailingList?key=AllExperts

Out of work? Know someone who is? Get a FREE copy of my Computer Job Skills CD at http://www.599cd.com/JobSkills?key=AllExperts

Add to this Answer Ask a Question