Search results

RESOLVED - filtering Report on the Fly I have a form with 5 fields. The 5 fields are choices from the columns (20) in a table and the person can select which fields they want in the report. If the person selects "Supervisor" as a field in any of the 5 combo boxes, then I want another combo box...

So I created a Field in my query that had the following: SchdlHrs: Format(Min([Hours]),"Medium Time") & "- " & IIf(Format(Max([Hours]),"Medium Time")="11:59 PM","12:00AM",Format(Max([Hours]),"Medium Time")) This fixed the issue. I can use the new field in my Pivots, forms and other reports...

They work Mon - Fri 3:00 PM - 12:00 AM. No dates are going to fix there schedule. If I was using a time punched in or out, then yes I would use Date/Time. I am using days worked and shifts.

RESOLVED .. 12:00 AM or Midnight I have employees in my database who work from 3:30PM till midnight. I am using a min or max to pull the employees time in and time out for a report showing the employees and there schedules. Right now I am using 11:59PM because if I use 12:00AM, it throws the...

RESOLVED Combo Box I have a combo box that lists Employee Last names. I have some duplicate last names. The combo box selection will populate a record for that employee so it can be updated. The problem is, when I have duplicate last names after selecting any duplicate last name it reverts the...