Recent content by kroden

I ran the first query with the calculation. I used that query in a second query to group & sum. The group & sum query groups by Location, RegistrationType, Year, Month, DayOfWeek and Hour; it also sums the # of registrations. I worked backward and forward grouping the different fields. The Hour...

That is what I did. It did not work. :confused:

Staff are taking donors a few minutes before office hours, but they are really processed the following hour - say they registered at 7:55 (they really are processed during the 8 o'clock hour.) The data is pulled from the registration system by the hour. The Director wants to look at how many are...

I'm new to the forum and have limited Access experience. I want to calculate the workload efficiency of staff in a blood center. Occassionally donors are registered before official office hours. I wrote an IIf expression to change the registration time (adding an hour) if the office is not...