Jump to content

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

Recommended Posts

Posted

I have a portal with two fields: Years & Date

I would like a function that would return the longest time in years along with the date associated with it.

Example:

PORTAL:

(Years) (Date)

2 1-5-05

4 5-6-05

Would like 4 & 5-6-05 Returned on the main page.

Help please

Joseph

Posted

Let me explan a little more on this:

I have a main Table with some calculation on it -- on this main table I have a portal that I type in two fields "Years" & "Date".

What I would Like to do is to beable to pull off to the main table from the portal the longest time in "years" along with the "date" associated with it.

Notes: There can be many entries into this portal. I need it to look down the full list.

Joseph

Posted

What do those relation fields signify? Can you tell us a little bit more about your database, maybe post an attachment? I'm having a hard time wrapping my mind around your current setup.

Posted

In Edit Relationship, make your relationship sort by Years, descending (in the portal setup, select another sort, if you like).

In the main table layout, put the Years and the Date fields from the related table on the layout - anywhere outside the portal. These will show the data from the related record that has the maximum value in Years.

Posted

Let me see if I can explan.

Main Table:

RecordID

First Name:

Last Name:

Address:

Also a Portal: Named "LE"

This portal is as you know another table "LE"

LE Table:

RecordID

Rel_RecordID

LE_Years

LE_Date

Relationships: RecordID -- Rel_RecordID

So what happens is that I full in a a new record with Name, address etc... Then what I do is I can type into the portal with very spefic reports -- like LE_Years and the date it came in. There can be many lines in this portal.

What I wanted to do is to be able to pull out the largest LE_Year in the Portal that is just a max function I know how to do this... This is the hard part... I want to pull out along with the LE_Year number the date that it was enterd -- LE_Date.

Joseph

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