Search results

When I put EmployeeName: [tb_Employeess].[Emplpyeel_Name] in the field line and tb_Employeess in the table line, and group by, when I run the query it asks me to type an employee name, and whatever I type is shown as the value for all fields in that column, regardless of what it should be. The...

Thanks Boyd, that definately looks like what I need to do. So, if I understand correctly, I should load the database to the SharePoint site, split it into back and front ends, and only publish the location to the front end? To continue developing the rest of the database, I would open a...

I have set the query up as suggested. I have tbl_SalaryChange one time, and tbleEmployees twice. One link from each employee in tbl_SalaryChange to the employeeID in tbl_Employee. However, to only show the latest record for each employee, I have to set all fields in the query to "last"...

Thanks, However, because the two fields point to the same field in the Employee table, I can't add them to the query (how would you know which is which?) and in order to find only the last salarychange for each employee, I have to make every field in the SalaryChange query "Last", except for...

Hello, I have two tables in question. tbl_Employee tbl_SalaryChange (will record each salary change for all employees) In tblSalaryChange, both the "AppliesTo" and "Approver" field are linked to the EmployeeID in tbl_Employee, as both fields specify an employee. I have not found way to...

Hello, I am creating a database in Access 2010 for HR to store its records and information. This database will be loaded into SharePoint server 2010 with Enterprise features. I need several people to be able to open and write to the database simultaneously without any issues. Does anyone...