Prev: Create Report using fields from Form's datasheet
Next: Import a PDF File into an Access 2007 Report
From: Tim on 27 Apr 2010 15:31
Can you show me how to calculate a short time, i.e., 13:35, so that the
result is 30 minute earlier; so it should show 13:05? Another example is:
13:05, the field on the report will show 12:35. Thanks!
From: KARL DEWEY on 27 Apr 2010 16:41
Adjusted Time: DateAdd("n", -30, [YourDateField])

--
Build a little, test a little.


"Tim" wrote:

> Can you show me how to calculate a short time, i.e., 13:35, so that the
> result is 30 minute earlier; so it should show 13:05? Another example is:
> 13:05, the field on the report will show 12:35. Thanks!
From: Tim on 30 Apr 2010 02:33
Perfect!

Thank you!

"KARL DEWEY" wrote:

> Adjusted Time: DateAdd("n", -30, [YourDateField])
>
> --
> Build a little, test a little.
>
>
> "Tim" wrote:
>
> > Can you show me how to calculate a short time, i.e., 13:35, so that the
> > result is 30 minute earlier; so it should show 13:05? Another example is:
> > 13:05, the field on the report will show 12:35. Thanks!
 | 
Pages: 1
Prev: Create Report using fields from Form's datasheet
Next: Import a PDF File into an Access 2007 Report