hi, i need your help with this: i need view a portal with date range, example:

list.fp5---

date name money

20/7/2003 tere 100

20/7/2003 karla 200

21/7/2003 tere 100

22/7/2003 tere 150

portal.fp5---

daterange1, date

daterange2, date

relationship..... rel by date: portal.fp5 daterange1::list.fp5 date

layout----

daterange1 ___________ daterange2 ____________

__________________________________________________________________

- ::date ::name ::money -

----------------------------------------------------------

- -

-rel by date _______________________________________________________

PROBLEM:

I want view the sum betwen 2 dates, i chosse from 20 to 21/7/2003 or from 21 to 22/7/2003

a daterange not by only 1 day. please somebody help me?

i am mexican, sorry about my english.

[email protected]

Hello Tere,

If I understand you correctly, there are two parts to your problem. The first is to get the range of records to appear in the portal according to date criteria - and the second is to produce the sum of money values for the records which appear.

There are various ways to set up relationships to return records within a range, and you'll find a few examples on various threads on this forum. However the following links may also be of interest:

http://www.nightwing.com.au/FileMaker/demos5.html#d4

http://www.onegasoft.com/tools/smartranges/

The methods described and demonstrated at the above links provide a selection of different approaches to establishing relationships based on ranges, and one of them may be suitable for your current requirements.

Once you have set up a suitable range-based relationship, you will be able to use the Sum(YourRelationship::YourField) formula within an unstored calculation field to retrieve summary and aggregate data via the relationship.

Thank you, i resolve my problem, your examples was very useful, thanks again.

Best regards.

Tere