Specifies an account interval or a list of account numbers.

The program will total the entries of the account numbers displayed in the field to give a total balance. How the field is completed depends on which account type you selected in the Account Type field:

• If the account has the type Posting, Begin-Total or Heading, the field must be blank.
  
• If the account has the type End-Total, the program will automatically fill in the field when you click Actions, point to Functions, and then click Indent Chart of Accounts. The accounts that are totaled are the ones that lie between one pair of corresponding Begin-Total and End-Total accounts.
  
• If the account has the type Total, you must fill in the field yourself to indicate which accounts will be totaled.
  

You can enter a maximum of 250 characters, both numbers and letters. The Totaling field is a kind of filter field because what is entered in the field limits the number of accounts used by the program to calculate the total balance. There are specific rules for what you can enter:

Meaning	Sample Expression	Accounts Included
Equal to	377	377
Interval	1100 .. 2100 ..2500	1100 through 2100 Up to and including 2500
Either/or	1200|1300	1200 and 1300
And	<2000&>1000	Those with a number less than 2000 and greater than 1000
Different from	<>1200	All except 1200
Greater than	> 1200	Those with a number above 1200
Greater than or equal to	>=1200	Those with number 1200 or above
Less than	<1200	Those with a number less than 1200

You can also combine the various format types:

Sample Expression	Accounts Included
5999|8100..8490	Account 5999 and accounts 8100 through 8490
..1299|1400..	Accounts up to and including 1299 and accounts 1400 and above, that is, all accounts except 1300 through 1399

See Also

---

© 2014 Microsoft. All rights reserved.