Re: Date/Time Average??
- From: "Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx>
- Date: Wed, 9 Nov 2005 18:36:49 -0500
Since diff2dates is returning a string, you can't use average on it.
Try averaging the difference in minutes (using DateDiff), and format that
into hh:mm.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"bladelock" <bladelock@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:14DDF1F8-1A29-4D03-8288-303A3BB72CC3@xxxxxxxxxxxxxxxx
>I have a report that works well, BUT, I have one problem. How do I get an
> average of the date and times on the report footer
>
> I'm using diff2dates on the report which works well:
> =diff2dates("hn",CDate([bed Dte] & " " & [bed time]),CDate([rec Dte] & " "
> &
> [rec Time]))
>
> Displays:
> 23 minutes
> 1 hour 23 minutes
> etc.....
>
> But When I put this code on the report footer, it doesn't work. I want to
> average this data on the report footer
>
> =Avg(diff2dates("hn",CDate([bed Dte] & " " & [bed time]),CDate([rec Dte] &
> "
> " & [rec Time])))
>
>
> This doesn't work?? Can some one help, I need to
.
- Prev by Date: Re: Can this be done via Access?
- Next by Date: Re: Keep together subReports
- Previous by thread: Can this be done via Access?
- Next by thread: Re: Date/Time Average??
- Index(es):
Relevant Pages
|
