Jump to content

Min and Max of Fields


This topic is 6684 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6684 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.