Recent content by Dirk Space

Not until I get back, on Wednesday. But here's what the Access part is. tblSchedules ID (auto random), Schedule <number assigned/entered>, Name, Sun1_Start, Sun1_End, Sun2_Start, Sun2_End, Mon1_Start, Mon1_End, Mon2_Start, Mon2_End... to Sat. This is repeated 400 times, 1 row for each...

Since it it can tell me if anyone with the last name Davidson has sold a Coke on a Wednesday in the past 30 years, with what discount code, and how many... just assumed this would be easier. I just have one table. Figured less info would be easier for it to accomplish things. Since a bus is...

That's why I said "that's a lot of rows on a table to enter" and not "I don't think it can hold that many rows." There is no need for a holiday table. I feel like my explanation has not changed, but been elaborated upon. I'll try again. Let me try and give an example: A call center can...

I don't think I will be able to. There's over 400 employees... times 7 days... plus the ones with more than 2 shifts in a day... that's a lot of rows on a table to enter. Plus, these are written and presented as schedules and bid on. Schedule 1 - specified times with specified days off...

I feel like I did, but maybe I don't understand what you are asking. These are the fields in the table (actually, there are more than 28, but the 28 are for the Start and End Times) and each is entered for that schedule: ID (auto random), Name, Sun1_Start, Sun1_End, Sun2_Start, Sun2_End...

I've tried that, but in their example there is one field for Date Booked, per guest. And that field is the only relevant field, when looking to see if it's booked, and to then sum that count. I've got 28 fields of start and end times, per employee, that can't take the place of one "relevant"...

That would be Employee 1 with a Start Time and End Time and the same for Employee 2. It doesn't seem to work with more than one Start Time and End Time field, for each employee. There are 28 fields for each schedule (4 Times for each day (2 shifts each with a Start and End) x 7 Days). If I...

Thanks. My bad. I got too clicky.

How does one create a temp table or "manufacture" non-existent values?

Thanks. The issue is I don't have a ClockInOutDate. It's not transactionary (action taken on a specific date), nor for the purposes of logs. It's just a 6 month schedule, with varying working dates and times on days of the week. There isn't any need to see if Janice is working on 01/25/2020...

I guess you could say, I'm looking at a specific point in time. This example illustrates how 2 employees would show up in an overview: Employee 1 Start: 12:00 pm End: 01:00 pm Employee 2 Start: 12:30 pm End: 01:15 pm 12:00 pm 1 12:15 pm 1 12:30 pm 2 12:45 pm 2 01:00 pm 1 01:15 pm 1 Since...

I thought it was explained properly... and I don't understand your new question. Employees can "Clock On" and "Clock Off" in 15 minute intervals; the total hours of the shift varies. 0800-1015 0315-1230 1545-1915 A calculated field that is looking at a "Clock On" time, uses this expression...

Well, actually it's per 15 minutes. I thought going by the hour would be easier in the example... Start: 12:30 pm End: 01:00 pm 12:00 pm 0 12:15 pm 0 12:30 pm 1 12:45 pm 1 01:00 pm 0 01:15 pm 0 And for each employee and summed, based on their set schedule. An overview would show...

Thanks. I've tried, but it wants an existing field to Crosstab with and all I have are Start Times and End Times. If I created a BUNCH of Start Times (Sunday Start Shift1 00:00, Sunday Start Shift1 00:15, etc.), then it could per Employee but that seems excessive.

I'm not sure if this is a Form or a Query issue; this is a change over from an Excel "database" (with all the fuzzy math it does to accomplish things). I have a table with 10 employees, each with a Date/Time-Short Time field for Start Time1 and End Time1, and Start Time2 and End Time2 (for...