selection formulas

[lborst01]

I am trying to seperate some dates to put into a summary report. There are 2 sets of dates: one is a start date and an end date and they are categorized under one field, and are labled as engineering or construction. The problem is that they are all grouped together and I cannot write a forumla that will allow me to show the dates under seperate headings, where I could take the lumped data and put it under 4 categories in a row for each project: Eng-start, Eng-end, Const-start, and Const-end. I wanted to use a select statement but that was not working, Any advice?

 

[synapsevampire]

Please provide sample data and expected output.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[lborst01]

Sample of Data:

Input has 2 fields:
jps_start_date
jps_end_date
The coding is found in jps_phase_code where it can be eng, constr, or dead. I have to take this information and write a formula that will allow me to display it as follows below.

I want to create a report where I have this output:

proj # Eng-Start Eng-End Constr-Start Constr-End
0001 01/15/200 06/04/2001 07/22/2001 09/01/2002


Each project will have listed the eng start and end date along the same row as the consturction start and end date and can then be grouped by dates or project #s etc