Search results for query: *

Gate Precast Log is the name of the database. I am having one thing that might be a spelling issue but I am not sure. In a query i calculate 2 fields and I call them:DMYield and DDMMixCost SELECT MixSample.DM_Mix, MixSample.DM_MaterialNo, MixSample.matTypeID, MixSample.materialID...

Hello, I have a form that for some reason is giving me an error. I have had this working for sometime now and it's just now producing this error: The expressin On Current you entered as the event property setting produced teh following error: A problem occurred while Gate Precast Project Log...

I am updating: vacationTime Here is the code: UPDATE Employee INNER JOIN vacationTime ON Employee.empID=vacationTime.empID SET vacationTime.vacaTimeEarned = [vacaTimeEarned]+4, Employee.empRestStatus = False, vacationTime.vacaTimeAwardDt = Date(), vacationTime.empID = [empID] WHERE...

Not sure I understood your last post. Are you suggesting that I just enter a negative number when they are using leave? I ask this because the user never adds leave manually, per se. It is assigned via an update statement that is launched when the user clicks a button. Partial time may be...

OK...so as to not re-invent the wheel, how can I store negative time taken? Would I need another field in the table to account for leave used?

I am glad you pointed that out :) This is what I am struggling with currently. I do not have a table representing this information. I used to have a field in the above table that kept track of used time,but was told that was un-needed bc it was a calculated field. I wondered if I was...

tblVacationTime -vacaID- PK Number -empID - FK Employee, Number -vacaTimeEarned - Number -vacaTimeAwardDt - Date

pwise, I apologize...this is not what I need. My issue is that I need to be able to record the hours a person uses...for instance a person can elect to take a fraction of the day off. How can I deal with that dynamic?

Hi pwise, Thank you for the reply. This works!

Hello, I am trying to calculate leave taken. I track leave by having the users input the days they are taking off. there is a reasonDtFrom and reasonDtTo for dates. I use the dateadd function to determine how many days that are being taken off, however I need it in hours. I realize I could...

PHV, SELECT DISTINCT E.empID FROM Employee AS E INNER JOIN (EmpIncidents AS I INNER JOIN DeptTrans AS T ON I.deptID = T.deptID) ON E.empID = T.empID WHERE (((I.incidentDt)<=[T].[transEndDt] And (I.incidentDt)>=DateSerial(Year(Date()),Month(Date())-2,1) And (I.incidentDt)>=[T].[transDt]) AND...

Yes I have; many time throughout this project :)

I need to check to see if the employee has transferred from a department with in the last two months to determine if there are any employees in departments that do not have incidents, that transferred from another department, which did have an incident. This means that although they are on a...

No, it doesn't.

I want all employees in a department, where a member of that department has had an incident. (If an employee has an incident, that means every employee in that dept is on restriction from receiving leave until the first day of the 3rd month. This list will be used to construct a list of emps...

Remou, I apologize, I did mean that I needed to include all employees in the matching department that had an incident. The results of your query returns ALL employess (and some duplicates); those that have an incident and those that do not, regardless of the dept.

Remou, Thank you for your p ersistance, however this list is not correct either...What information can i provide to assist? I expect this list to include employees who have had incidents as well as all other employees in the departments.

Hello: I removed that part and I am not getting the right employees.

Remou, Thanks for the repost. While I am able to get a result, it's not the correct results. it includes a record for an employee who transferred to another department from a department that had an incident, which means this employee should NOT be in this list.

Hi Remou, I appreciate your response. I was not able to get this query to produce any results, as I am receiving an error: Syntax error in Join operation. It highlights the DeptTrans in this line: FROM (Employee INNER JOIN (SELECT deptID FROM DeptTrans d