I am trying to create reports based on a value list in a bank register. I have a value list with a number of categories listed such as Electrical, Rent, Deposits, ect. I would like to create fields for the above categories (Electrical, Rent, Deposits) that would give me totals for each category. Is this possible?

The report would look something like this:

Electrical - Electrical total (field)

Rent - Rent total (field)

Deposits - Deposits total (field)

Thanks in advance

Are you saying that you have an option in each record to select from a value list how a value entered into an Amount field should be applied and you want to summarize these values for a report? If so, would this be a report that is strictly previewed and printed, or would you want the totals visible on every record in Browse Mode?

"Are you saying that you have an option in each record to select from a value list how a value entered into an Amount field should be applied and you want to summarize these values for a report?"

I can create an amount field for each category such as fields for Electrical, Rent, ect. I would like those fields to be totals of each category. These fields then can be shown in a report.

" If so, would this be a report that is strictly previewed and printed, or would you want the totals visible on every record in Browse Mode?"

It would be great if these fields could be viewed in Browse Mode, but if the only way to display them is in the Preview mode, then that would be ok.