Jump to content

getting a particular value from a set of related records


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

Recommended Posts

I would like to get the value of a field from a related set of records.

The value would be from a whichever record has a second field (date) which is the most recent.

Wow - hope that made sense!!

eg

record1 - field1=35, field2=2nov2002

record2 - field1=12,field2=2jan2007

result=12 as field2 has the latest date

thanks

Link to comment
Share on other sites

Thanks for you good suggestions. So i dont get thrown by a resort I found an alternate method.

I created a new field Max(datefield) and then created a new relationship using this max field to have access to the relevant fields.

Link to comment
Share on other sites

This topic is 6079 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.