Search results

Thank you Thanks for all the replies and help, the function works as needed!

Thanks Thanks for all that have offered their insight....Jon K's query provides the results that I am looking for. I do have a question about what is necessarywhen the range crosses midnight (2200-0600)? What values are needed to pass in to this query or do I also need an additional query for...

thanks for the quik reply But... What about people that are on the edge of that time frame...... I want to find out everyone who is working betweeen the hours of 14:00 and 22:00....... data in tables: ID/startdates/enddates 1/0600/1400 2/0600/1400 3/1100/1500 4/1200/1600 5/1400/2200...

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 got it working I tried it with a crosstab query and it is working with my test data SO FAR. Lets hope it works all the way through. Here is my SQL statement TRANSFORM First([Select Month Schedule].shift_type) AS FirstOfshift_type SELECT [Select Month Schedule].shift_position, [Select Month...

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 that I have the dynamic where clause, and I am passing it into the report like this: DoCmd.OpenReport "Crime Numbers", acViewPreview, , WhereString (Where string is a string that contains the where clause, without the "WHERE") The problem is when I try and run the report from the form...

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...

Thanks That was just a sample of what should come back. The events can take place over any number of days. I will give the program a try and let you know how it worked. Thanks again for your help and input.

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...