Min and Max of Fields

[The Big Bear]

Hi all

I want to choose the min date and max date when all welder were tested. Each welder may have four or five tests but i just want to know when each welder was first tested and when he was last tested along with the first process and last process he was tested on and i want to displayed this information on one line for in a view layout for each welder. I have tried various ways but have not achieved the results i was hoping to get. Included is a sample program of what i would like to do

Any help or suggestion will be greatly appreciated

Thanks in advance

Lionel

test.zip

Edited August 20, 2005 by Guest

[-Queue-]

There's nothing in the attachment, but if you sort your relationship by date ascending, then Relationship::Field refers to the earliest record's Field value and Last(Relationship::Field) refers to the most recent record's Field value.

[The Big Bear]

Hi Quene

Thanks for the information. I got it to work.

One more question? In a colimnar list/report layout. is it possible to displayed only one record for each welder no matter if each welder has five or more records in the db.

Example

name Mindate process mandate process

Terry 1/3/05 SMAW 7/5/05 GTAW

Ronnie 1/7/05 SAW 8/1/05 SMAW

and so on

Thanks in advance

Lionel