If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
How Many Employees Were At Work At 10:00am?
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 |
#3
|
|||
|
|||
How Many Employees Were At Work At 10:00am?
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 |
#4
|
|||
|
|||
How Many Employees Were At Work At 10:00am?
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 |
#5
|
|||
|
|||
How Many Employees Were At Work At 10:00am?
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 |
#6
|
|||
|
|||
How Many Employees Were At Work At 10:00am?
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 |
Thread Tools | |
Display Modes | |
|
|