Suming accounts

[stevejd]

I have a chart of accounts for several branches, with a branch number at the
end of each account number. 540062-1, 540062-2, 540062-3, 540062-5. and so
on.
What I am trying to do is combine the account numbers to 540062 with all
branches showing up in the total. Is there a way of doing this in the
criteria or in a report? Most of my exp. is with simple queries.

 

[KARL DEWEY]

Use Sorting and Grouping and group on Left([Account], 6) with a footer.
In group footer add text box with =Sum([Account])

 

[KARL DEWEY]

Use Sorting and Grouping and group on Left([Account], 6) with a footer.
In group footer add text box with =Sum([Account])

 

[Jeff Boyce]

I'm with Karl ... provided you are ABSOLUTELY certain you will ALWAYS have
six-digit account numbers.

A couple of wrenches in the works ...

* what if the account number is shorter than 6 characters?
* what if the "account number" includes alpha characters?
* what if the account number begins with one or more zeros (like some zip
codes in the US do...)?

Good luck!

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.