Recent content by Yam84

I don't understand. What do you mean about the dept table? I have a dept table: Employee: empID- pk, empNo, empName Dept: deptID- pk, Dept DeptTrans: deptTransID- PK, empID (FK), deptTransDt (date of transfer)

In my mind, that's what the Incident table is...it tells who made the incident (empID) and from where (deptTransID) and the type of incident, which determines if they are awarded leave or not. I do this in a query. I just needed a way to penalize a whole department, based on the deptID in the...

The DeptTrans table is the table that keeps track of each dept an employee has belonged to. Basically employee transfer history DeptTrans: deptTransID- PK, empID (FK), deptTransDt (date of transfer)

OK...As I said, since I keep a DeptTrans history table, could I just use that ID as opposed to the deptID in the empIncident Table: tblIncident IncidentID (pk) empID (fk) (One emp can have many incidents) deptTransID (fk) (One dept can have many incidents) IncidentTypeID etc If this table...

OK...so if I follow you, you are just saying add the FK from the EmpIncidents entity (incidentID) to the employee table and the dept table? Then the relationship would be: One EmpIncident to Many Employees? Currently it is the other way around, which is how I thought it should be since many...

Well, I was thinking about that and I am not quite sure. Currently I have an incident table that has empID (PK from employee). If I make it an attribute of department, when an employee transfers, won't the current status of the department affect the employee? For instance if I transfer to...

Hello: I have an idea for a function (or what i think could be a function) and I wanted input as to whether or not it is do-able. The process says that employees are awarded leave on a monthly basis, if no employee in a certain department has an incident. If an employee does have an incident...

Hello: I am have created a query which tells the user where a panel is at a certain time. I have two queries that I combine to get my results. the first query results in the return of all times a panel has moved. SELECT [Project Information].jobNumber, [Project Information].jobName, [Yard...

Hello, I am having some trouble using a calculated field to accurately determine the amount on hand. I have a UNION query which joins two queries. The first query uses the amount of stock of an item joined with the items that have been checked out. I use these numbers to calculate the...

Thanx Jal. I see how you got yours to work and tried to model mine after it, however, did not get the same result. I noticed that in your query 1, after it is ran, it prompts for a quantitycheckedout, i click enter to bypass this and it returns to me a table w/ two negative values for two...

I understand your suggestion, however it will only work until the checkout record is edited to reflect the check in. there is only one record, not two. If there were a record being created for checkins, i believe your suggestion would be possible. Maybe I should create it so that there is a...

Hello: I have created a query which tracks items that are checked out and purchased from stock. I have a purchasetype tbl which identifies they type of transactions. 1-3 deduct from stock, while 4 (indicates an item that was checked out is checked back in) adds to stock. I have created a...

thank you for this response...Should I place it in the before update section of my text box?

Good Afternoon, I have a form created that is used to check items in and out. If an item is checked out, they have 1 day to check it back in. i would like create a macro or use an IF statement to generate a msgbox to let the user attempting to check something out, who currently has something...

Normalized Correctly Thank you for your response. I have remedied the issue by creating two queries. One calculates the amount of a product currently checked out. The other uses that amount and subtracks it from the sum of the current stock for each product which calculates the amount on...