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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report projects by action dates

Status
Not open for further replies.

MAPetry

Technical User
Aug 2, 2000
43
0
0
US
I have a report that I need to print a list of projects and their associated "action dates"

Report is generated from 2 tables 1.) projects, 2. )Project Actions

Need report to print in the following sort order:
1.) Project Type (Field of Project table)
2.) by action date. (listing the next upcoming first of all actions associated with each project)

Example:
1 - Action A
Project 2 Mar 1, 2002 - Proj Action 1
Project 3 Mar 6, 2002 - Project Action 1
Apr 5, 2002 - Project Action 2
Project 1 Mar 31, 2002 - Project Action 1

2 - Action B

Trouble I am having.
Can not get to sort by date and list all dates in same spot

I can sort by project name and list all action dates but that is not what I want.

Any Help?? Please!!!

Thanks
MAP
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top