Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with formula needed -

Status
Not open for further replies.

SeeBee

Technical User
Mar 18, 2002
31
0
0
US
I have voucher numbers and dollar amounts that are duplicating - in some instances, not all.
How do I write a formula that would say:
look at the voucher number and the dollar amount, if they are repeated, then delete/omit from grand totals for each field (Voucher, Dollar Amount).
Thanks in advance for your help,
seebee
 
Create a group for voucher# and a second group for dollar amount.
Create a running total for dollar amount. In the "Evaluate" section, select "on change of group" and select the "dollar amount" group from the drop down list.
In the "reset" section select never.

MrBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top