Need help with Calculation ??

  • Thread starter Thread starter shelley kline
  • Start date Start date
S

shelley kline

Hello - I need some help with a query calculation in my
access 2002 database:

I have two date fields [ORG_EST_TO_CLIENT_DATE] and
[ORG_EST_APPROVED_DATE]. What I would like to calculate
is the days between the two dates - how do I do this? And
.. where do I put the calculation? Is this a query or a
report, or can I put it into my form?

Thanks so much!
 
You can place the calculation in a report, form, or query.
It just depends upon where you need the result.

In a query:
DaysElapsed:DateDiff("d",[ORG_EST_TO_CLIENT_DATE],[ORG_EST_APPROVED_DATE])

In a Report (or Form) Unbound Control's ControlSource:
= DateDiff("d",[ORG_EST_TO_CLIENT_DATE],[ORG_EST_APPROVED_DATE])

Or you can simply subtract one date from the other:
= [ORG_EST_TO_CLIENT_DATE] - [ORG_EST_APPROVED_DATE]
 
thanks!
-----Original Message-----
You can place the calculation in a report, form, or query.
It just depends upon where you need the result.

In a query:
DaysElapsed:DateDiff("d",[ORG_EST_TO_CLIENT_DATE], [ORG_EST_APPROVED_DATE])

In a Report (or Form) Unbound Control's ControlSource:
= DateDiff("d",[ORG_EST_TO_CLIENT_DATE], [ORG_EST_APPROVED_DATE])

Or you can simply subtract one date from the other:
= [ORG_EST_TO_CLIENT_DATE] - [ORG_EST_APPROVED_DATE]

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Hello - I need some help with a query calculation in my
access 2002 database:

I have two date fields [ORG_EST_TO_CLIENT_DATE] and
[ORG_EST_APPROVED_DATE]. What I would like to calculate
is the days between the two dates - how do I do this? And
. where do I put the calculation? Is this a query or a
report, or can I put it into my form?

Thanks so much!
Click to expand...


.
Click to expand...
 
Back
Top