Query

[Guest]

How can I write a query that looks at the first 3 digits for sorting via a 9
digit account #

 

[Rick Brandt]

How can I write a query that looks at the first 3 digits for sorting
via a 9 digit account #

Since sorting starts at the first digit or character, then the second, etc., how
will sorting on the first three characters be any different than just sorting on
the entire field?

 

[Guest]

The first 3 digits are consider sub funds with in the account # it's self.
What I really need it for is:

my orig. query is sorting by fund for a report. Made a separate fund table
Listing sort order based on spec. fund category and linked it to the orig.
table for sorting and calculating. Pretty simple! I have sub totals added
to the report as well.

Now, within the org. table list "account #’s" and within the "account
#’s" are sub funds – 1st 3 digits nested in the 9 digit "account #’s". I
need to break my query down further for only one of the orig. funds 84 based
on this criteria and sub total for each sub fund.

Can you help with this addititional step. I'm at a loss. I thought asking
the first question may help me understand how I get to the end result above.

 

[Guest]

Additional info. 26 sub funds nested with in many of those 9 digit accounts
that payments are received for.

 

[Rick Brandt]

Additional info. 26 sub funds nested with in many of those 9 digit
accounts that payments are received for.

I fail to see why that additional info is significant. Perhaps if you posted
small samples of your raw data and what you want your query output to look like
we can figure out what you need.