Search results

I have a table that consists of [employee], [scheduledate], [starttime] and [endtime]. I need to query this table to get the total of all employees working during a certain period of time (ex. 1400 - 2200). I have been pondering this for quite a while and have yet to come up with something...

I have a table with the following info: Date/shift/name 1-1-07/1/tom 1-1/07/1/Bill 1-1-07/2/frank 1-1-07/2/Ben 1-1-07/3/Scott 1-1-07/3/Terry 1-2-07/1/tom 1-2/07/1/Bill 1-2-07/2/frank 1-2-07/2/Ben 1-2-07/3/Scott 1-2-07/3/Terry 1-3-07/1/tom 1-3/07/1/Bill 1-3-07/2/frank 1-3-07/2/Ben 1-3-07/3/Scott...

I have a report based on the following saved Query: SELECT Crime_Table.Offense, Count(*) AS [Number of Crimes] FROM Crime_Table GROUP BY Crime_Table.Offense; What I want to do is be able to pass in a where clause that is generated from a form. Is this possible? Would I need to change the...

I have a table that has a start day and end day. I would like to get a total for all events occuring on the days of the week (mon, tues, etc.). The problem I am having is when the start day and end day are not the same I need to count that event for all the days in between also. Example...

I have a table that has a start day and end day. I would like to get a total for all events occuring on the days of the week (mon, tues, etc.). The problem I am having is when the start day and end day are not the same I need to count that event for all the days in between also. Example...