Hi
Im new to Access reports(clueless) and Im trying to produce a report that will group task operators together.
I have 4 tasks per project (Task1,Task1by,Task1Deadline, Task2,Task2by,Task2Deadline etc.)
My problem is How can I group Tasks by together? I have a table of Employees that I'd like to cycle through, compare and group together in a report.
Something like;
Code:
Do Until Recordset.EOF
if [Task1by] = [tbl EmployeeList].[Employee] then
[i]Write data[/i]
[Task1].write = True
[Task1by].write = True
[Deadline1].write = True
End if
[tbl EmployeeList].[Employee].MoveNext
loop
I'd like it to group together all the tasks done by each employee and write them to the report.
At the moment I have to match an employee name to (Task1 Or Task2 Or Task3 etc.) and print a block of all data rather than a filtered neat one liner.
So
Could anyone please tell me how to write/Not write to a report?
Any advice of the structure of my code?
Many thanks