Re: thread703-1592285 / Access 2000 report [user] issue

[boone35223]

Below is the SQL view of the crosstab query.

TRANSFORM Sum(employee_checks_dist.pr_check_amt) AS SumOfpr_check_amt
SELECT employee_checks.pr_check_to, Sum(employee_checks_dist.pr_check_amt) AS [Total Of pr_check_amt]
FROM (employee_checks_dist INNER JOIN employee_checks ON employee_checks_dist.pr_check_no = employee_checks.pr_check_no) INNER JOIN employee ON employee_checks.pr_check_to = employee.pr_ssn
WHERE (((employee_checks.pr_check_date)>#9/1/2009#) AND ((employee_checks_dist.pr_check_kind)="+" Or (employee_checks_dist.pr_check_kind)="-"))
GROUP BY employee_checks.pr_check_to, employee_checks.pr_check_date, employee.pr_emp_name, employee.pr_emp_firstname, employee_checks_dist.pr_check_kind
PIVOT employee_checks_dist.pr_check_categ;

In order to link employee address and other data, I have created another query (select) from the above crosstab query. The select query is the one I am attempting to build the report from.

 

[dhookom]

Please disregard this thread and refer to the thread in the title.

Duane
Hook'D on Access
MS Access MVP