Hi Terry,
I would create a calculated field with the time slice in it for grouping. Maybe something like this:
clng(([YourDateTimeField]-#1/1/2000#) * 4 * 24)
WHERE
1/1/2000 is some base date below your data
* 4 because you want 15 minute increments
* 24 because there are 24 hours in a day
cLng will round -- perhaps you prefer to use Int
when one date/time is subtracted from another, the whole part of the number is the days. The fraction represents time through the day
Merry Christmas!
Warm Regards,
Crystal
Access Basics by Crystal (Bill Mosca's site)
http://thatlldoit.com
Free 100-page book that covers essentials in Access
*
(: have an awesome day :)
*
________________________________
From: Terry Olsen
Hi
Any thoughts on filters in pivot table views?
Thanks
Happy Holidays
Terryomsn
--- "Terry Olsen" <terryomsn@...> wrote:
>
> Hi
> I need to create a pivot table to see when coaches connect to a network. The pivot would display time slices of 15 minutes within date.
> I have several thousand rows that include a date/time field. The values include the seconds field (General format -m/d/yyyy h:nn:ss AM/PM).
> I need to find a way to slice these rows into 15 minute increments for the pivot to be useful.
> The Inside Access 2010 book was very helpful in how to create the basic pivot view, but I'm not finding information on the net or in Access Help to carve up my data.
> Any help would be appreciated,
> Thanks,
> Terryomsn
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar