How Many Employees Were At Work At 10:00am?

Employee StartTime and FinishTime are stored, and I'd like
to make a query that will show the number of employees
present for each hour during the workday.

Eventually, I'd like to make a line chart showing employee
totals by the hour.

Access 2000.

Stumped!

I've been trying statements in query fields to output "Yes"
if an employee was present at a given time, but only getting
"invalid number of arguments" with things like this:

H800: IIf(#08:00# between [StartTime] and [FinishTime],
"Yes"

Any ideas?

--
Thanks,
tbl

H800: IIf(#08:00# between [StartTime] and [FinishTime],"Yes"
is missing:
,"No")
a the end.

--
Duane Hookom
MS Access MVP

"tbl" wrote in message
...
Employee StartTime and FinishTime are stored, and I'd like
to make a query that will show the number of employees
present for each hour during the workday.

Eventually, I'd like to make a line chart showing employee
totals by the hour.

Access 2000.

Stumped!

I've been trying statements in query fields to output "Yes"
if an employee was present at a given time, but only getting
"invalid number of arguments" with things like this:

H800: IIf(#08:00# between [StartTime] and [FinishTime],
"Yes"

Any ideas?

--
Thanks,
tbl

On Sat, 18 Nov 2006 08:31:07 -0600, "Duane Hookom"
DuaneAtNoSpanHookomDotNet wrote:

H800: IIf(#08:00# between [StartTime] and [FinishTime],"Yes"
is missing:
,"No")
a the end.


Thanks Duane!

For some reason, I had it in my head that the second
argument(?) wasn't necessary, and as the experiments in
syntax proceded, forgot to question the most common culprit
in my exasperations library--my memory. Ugh!
--
tbl

On Sat, 18 Nov 2006 08:31:07 -0600, "Duane Hookom"
DuaneAtNoSpanHookomDotNet wrote:

H800: IIf(#08:00# between [StartTime] and [FinishTime],"Yes"
is missing:
,"No")
a the end.


Thanks for that! Back in business... sort of.

This task is becoming a real challenge for me, and I'm
begiining to wonder if I'm on the right track at all. Maybe
I should be using an array, or some kind of For Each type
statements (???). I've never done any of that before, so
I'll refine my question:

If any of you experienced folks were wanting to make a
line-graph to show hourly totals of employess "punched in",
how would *you* go about it? ;-)

--
Thanks
--
tbl

I will butt in with a general point, if you want to ask a new question it is
often better to start a new thread. There are people, like me, who often
view by thread, concentrate on questions where I might learn, where I might
be quickest to answer, or where I have specialist knowledge. (In that order,
regretably.) A graph whiz kid might like to step inon this one, if he/she
could see it. We are also building a repository of knowledge accessible via
Google groups search, and it helps to have relevance in the titles.

"tbl" wrote in message
...
On Sat, 18 Nov 2006 08:31:07 -0600, "Duane Hookom"
DuaneAtNoSpanHookomDotNet wrote:

H800: IIf(#08:00# between [StartTime] and [FinishTime],"Yes"
is missing:
,"No")
a the end.


Thanks for that! Back in business... sort of.

This task is becoming a real challenge for me, and I'm
begiining to wonder if I'm on the right track at all. Maybe
I should be using an array, or some kind of For Each type
statements (???). I've never done any of that before, so
I'll refine my question:

If any of you experienced folks were wanting to make a
line-graph to show hourly totals of employess "punched in",
how would *you* go about it? ;-)

--
Thanks
--
tbl

On Tue, 21 Nov 2006 12:29:37 GMT, "David F Cox"
wrote:

I will butt in with a general point, if you want to ask a new question it is
often better to start a new thread. There are people, like me, who often
view by thread, concentrate on questions where I might learn, where I might
be quickest to answer, or where I have specialist knowledge. (In that order,
regretably.) A graph whiz kid might like to step inon this one, if he/she
could see it. We are also building a repository of knowledge accessible via
Google groups search, and it helps to have relevance in the titles.


Thanks David.

The boss' metting is history and I couldn't get the chart to
him in time. But I will follow up elsewhere as you suggest,
just out of personal interest.
--
tbl