Search results

thank you for response, but I am not sure how this solve the problem? in update query lastname=lastname, firstname=firsname and criteria is ofr employeeID=null, then employee ID filed would be updated with null value? am i missing something from your answere? employeeID's are not autonumber...

have a employee database table with four columns 1. LastName 2. FirstName 3.employeeID 4.DocumentType So each employee is one or more times in the table, but not all the rows have the Employee ID in them. I want to find the empty field, then check the Lastname and firstname and compare it with...

I need help, have 17,000 files cross 9 different directories, have an access database with a column with files's path. How can I make sure that the path for individual files are correct and files exist in directories that databse indicates they are.

thank you, i would defineltly try that

I started off to make a simple time sheet for our small firm employees to records their in and out time. associateDetailstbl. contain all the information with all their contact info. AssociateID is the primary key then made a table query of above table to capture primary key, first and last...

I want to keep track of IT assets in 7 different departments. But want to make it a bit user friendly. like to have a form that end user can go to and input the number of items, let say 20, then their department let say HR, and type the type of assets let say PC. I have my tables, ASSETtbl...