Any help would be greatly appreciated.

[gusc999]

Good Afternoon,

I’m trying to figure out how to create query that will group the times by half hour increment and count them by those increments, in the [RHPRTT] field (military time). The query statement below was the one I used to generate this query below.

Any help would be greatly appreciated.

SELECT PIRF_TRKEXTF.RHRTE, PIRF_TRKEXTF.RHIMPD, PIRF_TRKEXTF.RHIMPT, PIRF_TRKEXTF.RHPRTD, PIRF_TRKEXTF.RHPRTT, PIRF_TRKEXTF.TRUSER
FROM PIRF_TRKEXTF
WHERE (((PIRF_TRKEXTF.RHPRTD)=[20080131]));

RHRTE RHIMPD RHIMPT RHPRTD RHPRTT
301 20080304 164750 20080304 165808
302 20080304 164750 20080304 165829
303 20080304 164750 20080304 165855
304 20080304 164750 20080304 170414
305 20080304 171622 20080304 171948
306 20080304 171622 20080304 172041
307 20080304 174345 20080304 174640
308 20080304 174345 20080304 174810
309 20080304 174345 20080304 174828
310 20080304 174345 20080304 174904
311 20080304 181956 20080304 182658
312 20080304 181956 20080304 183114
313 20080304 181956 20080304 183216
314 20080304 181956 20080304 183331
315 20080304 181956 20080304 183745
316 20080304 181956 20080304 184117
317 20080304 182536 20080304 184250
318 20080304 182536 20080304 184929
319 20080304 183705 20080304 185009
320 20080304 183705 20080304 185103

 

[dhookom]

gusc999,
There is at least one reply in the Queries forum where you asked the same exact question. Please be patient and limit your questions to a single, appropriate forum.

Duane
Hook'D on Access
MS Access MVP

 

[gusc999]

ok