Query issues

[hudaz]

Hi everyone,

I'm stuck on a query and wondered if you guys may be able to help.

Basically we log efficiency manually and it is meant to be done every hour. I want to list the data in a query so that if the efficiency is logged at 9.47am it will show up like the example i've mocked up below:

7-8
8-9
9-10 95%
10-11
11-12
13-13
etc
etc

how would i be able to create a query that performs like this, It needs to be done this way so that missed efficiencies can be logged retrospectively in a listbox. I'd appreciate any help, i'm kinda stumped!!

 

[Ranman256]

Q1 would count the items in the Hour blocks,
Select count(item) ,"09-10" as Block from table where [time] between 9am and 10am

Q2 would use Q1 and calc the percents.

 

[hudaz]

Hi Ranman256,

Thanks for getting back to me!. So would i have to do an individual query for each hour block in Q1 ?

 

[Ranman256]

That would be easiest. Put the all in a macro.