Aggregate functions with date ranges

[Tombstone0]

I need to create a summery which displays the total amount a particular office in my company has billed another company in a particular time frame. So far I've figured out how to sum the total amount based on company number and office through a relationship concatinating the two fields. My question is how do I limit the total by a time frame?

[tlsparker]

Create a text field called "marker". Enter the date ranges in global fields (gFirstDate, gLastDate). Create a script that includes:

Find All

Set Field (Marker="")This step clears the marker field.

Set the date search field to (gFirstDate&"..."&gLastDate)

Perform find.

Set Field (Marker="x"). This script marks all the records you want to include in the total with an x.

Now, append the marker field to the concatenated field you described, base the relationship on this new field, and you should get your total for the date range.

[bobsmith]

You can not use SetField as this will only effect the current record not the found set. You will need to use Replace or use a loop to set the field and move to the next record and set the field.

[tlsparker]

"You can not use SetField as this will only effect the current record not the found set. You will need to use Replace or use a loop to set the field and move to the next record and set the field."

Ah, yes, Replace is the correct command in this case.

Tom