Search results

Thanks! I really appreciate it. I looked at the example but I don't understand the fConList portion. It looked like a function, but when I try to duplicate it, I get an error. What exactly is fConList and how do I use it?

Hello, I seem to have a similiar problem to others and I tried to read through this forum, but I am not well versed in the code and I frankly find some of the explanations way to complicated. I was hoping someone can help me with a problem. I have data that looks like this: Name...

Hi there, I need some help with calculating login/logout times. I have an ODBC link set up for the raw data in AVAYA. The problem is that the login/logout times are reflected as the number of seconds that have passed since January 1st, 1970. I need to know what that amount in seconds is in a...

I'm afraid that I was having difficulty with a cross-tab query which is what brought me to this forum in the first place.

Hi Folks, I'm doing a Schedule Adherence Report in Access. One table has the schedule start time and stop time. The second table has exception times (lunches, breaks, etc). Both tables have the common denominator of a unique Schedule ID. How do I bring them together with repetitive Schedule...

Thanks. I tried that but still no go. It excludes the days that don't appear in the main table. Any other suggestions?

I have two tables. One is a simple two column table with Short Date and the corresponding Day of Week. My second table is an employee schedule based on Day of week. I bring the two together by the "Day" variable to generate a schedule for a specific time period, but I also want it to return...

The theory is sound. Thank you so much. It is greatly appreciated.

Hi everyone! I need some help. Here is my table: NAME START TIME STOP TIME J SMITH 12:00:00 AM 6:00:00 AM S SMITH 3:00:00 AM 7:00:00 AM Z SMITH 5:00:00 AM 1:00:00 PM I want to calculate how many people work...

Hi folks! I'm a new user and need a hand. I'm running a query with two tables joined. I have 4 columns: Name, Day of Week, Date, Start Time. I want to create a 5th column that will number each record: 1,2,3,4,etc. I've tried researching help with indexes and primary keys etc. The main...