Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

New to Reports

Status
Not open for further replies.

RichCraig

Programmer
Feb 13, 2003
54
GB

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

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top