Portal - Extensive Date Summary

[leberhar]

I have a portal which lists dates, times and ticket prices of the performances of a show, an example is below:

Friday, June 4, 2004 8pm $13.00

Saturday, June 5, 2004 8pm $12.00

Friday, June 11, 2004 8pm $12.00

Saturday, June 12, 2004 8pm $12.00

Sunday, June 13, 2004 3pm $11.00 or 2 for $20.00

Friday, June 18, 2004 8pm $12.00

Saturday, June 19, 2004 8pm $12.00

From the portal information above, I can easily get the dates of the run of the production:

min (Performances::PerformanceDate)

max (Performances::PerformanceDate)

Now, what I need in addition to this is a condensed version of the portal above, to the tune of:

Friday, June 4, 2004 at 8pm, tickets $13.00

Fridays & Saturdays, June 5, 11, 12, 18, 19 2004 at 8pm, tickets $12.00

Sunday, June 13, 2004 at 3pm, tickets $11.00 or 2 for $20.00

Can anyone possibly lead my brain in the right direction to conjure up a calculation that could do this?

Thanks,

Lisa

[djgogi]

In related file define an aux self relationship based on field price, actually you'll need an extra field that will include the show ID as prefix:

So the field self rel is based on should be:

ShowID & " " & ticketPrice

Now define an value list based on this self relationship (this one should be sorted on second field wich is the show's date field).

Then define another calc field for getting items from the above value list:

ValuListItems(Status(currentFileName), here the name of the list )

Finally using the text manipulation functions you should find the way to put it in desired format.

Dj