field calculation problem

J

Joe Willie

Is it possible to have a total of time in a field that is
a combination of two date formated fields?

For example -
one field might show 8/1/3 and another field might show
8/8/3. I would then want the third field to show 7 for the
amount of days between the first two fields. Any help is
truely appriciated.

Thank you, Joe
 
L

Lynn Trapp

In a Query you can simply calculate the difference:

DaysBetween: [DateField2] - [DateField1]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the right style field in VBA 0
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Countdown macro - display settings 2
Need some PWA help 0
Is this possible? 0
Split form 0
Link a text box based on drop down box with four options MS Word 365 0
ASK Field Formatting 1

Top