Search results

I am trying to send a report to a list of employees. I have a query that generates the report into the layout I want and includes the e-mail address of who the recipient should be. The report looks something like this: --Employee Name-- --E-mail address--- -Hire Date----Tenure- -Attendance-...

I've worked it out. I added the following clause: WHERE Parameters.Department = Inventory.Department This gives me the output I need.

So just include the tables, and the fields in the query. SELECT Inventory.employeeID, Inventory.Name, Inventory.Department Parameters.ParamName FROM Inventory, Parameters But what if I need only certain rows from the Parameters to be included depending on what the department is? My parameters...

I am trying to build an incentive calculator for my company. I need a query that will take, for each employee, Append rows as follows: Emp1 | Attendance | Emp1 | CSAT Score | Emp1 | Quality Score | Emp2 | Attendance | Emp2 | CSAT Score | Emp2 | Quality Score |...

This relationship can be accomplished using a query. Setup a SELECT query and use an expression to return only what your want from the "position 2" field. The expression (as a query column) would look something like... LinkID: Right([Position 2], 4) which would take the table: Position 2 |...

Try building your WHERE clauses into the queries below, or better yet, build another SELECT query that only uses the UNION query as a source. If neither works, your WHERE has an issue.

For some reason access 2010 seems to allow my macros to run just fine when I get the security prompt to enable macros, everything runs fine. When I press the "Enable" button, my macros fail due to action being disabled. It's like the security settings are acting in reverse. I have tried turning...