Date Calculation

[Tim L]

I need to be able to calculate total days of storage. How can I get this to show up in a form

"Date in - date out = total days"
I have my form with date in, date out, total days fields.

Any help would be great.

 

[Jeff Boyce]

Tim

You posted to a "tables"-oriented newsgroup, so I'll assume you are asking
how a form can display the fields from your table...

Or, if I re-read your post, are you asking how to calculate "total days",
given [date in] and [date out] values in a table?

Are you even talking about a table?!

More info, please...

Jeff Boyce
<Access MVP>

 

[Tim L]

How do you calculate total day

----- Jeff Boyce wrote: ----

Ti

You posted to a "tables"-oriented newsgroup, so I'll assume you are askin
how a form can display the fields from your table..

Or, if I re-read your post, are you asking how to calculate "total days"
given [date in] and [date out] values in a table

Are you even talking about a table?

More info, please..

Jeff Boyc
<Access MVP>

 

[Guest]

your first problem is that

[date OUT] - [date IN] = total days

-----Original Message-----
I need to be able to calculate total days of storage.

How can I get this to show up in a form

 

[Jeff Boyce]

Tim

Again, you are in a "tables" newsgroup, but discussing "forms" issues (for
your future clarification).

If you create a form, bound to your table, and include the [Date in] and
[Date out] fields (by the way, use the brackets when your field names have
spaces) as text controls on the form. Now, add an unbound text control, and
set it's control source to:

= [Name of your Date Out control] - [Name of your Date In control]

Good luck

Jeff Boyce
<Access MVP>