Need help writing script

[GreenPilgrim]

I'm not getting any replies so I'm guessing my problem wasn't stated clearly. I'm going to try to explain what I need, but please be patient as I'm not that good at this.

I have a report that has a summary field of all the pmts taken in for a day.

We are adding the form of payment being taken in; cash, check, credit card, money order, or other. This text field is being added next to each individual payment.

My boss wants a total of payments taken in by each individual method. So I need to create a field for cash, credit card, money order and other individually to give him a total for each method.

I am at a stall as I don't know how to define the fields or write scripts to make this happen. Any help is greatly appreciated.

Edited July 10, 2008 by Guest

[comment]

All you need is ONE summary field (total of payments) and a sub-summary part (when sorted by PaymentMethod) on your report layout. You can delete the body part if all you want is the sub-totals.

[GreenPilgrim]

The reason I double posted was because I realized I had probably started my original post on the wrong forum. Sorry, it won't happen again.

Thanks for the help.

[GreenPilgrim]

The trouble I am having is that the summary field needs to summarize the last entry on all records that have an entry on that date, on a repeating field.

The pmt method is showing the first value in the repeating field and not the last. I'm trying to fix it in the repeating fields value but it's not working.

[comment]

Each payment needs to be a separate record in a Payments table. If I understand correctly, you now have a table where each day is a record, and each payment is an entry in a repeating field? That won't work if you want to summarize your data.