R
Renetta
How can I write a query that looks at the first 3 digits for sorting via a 9
digit account #
digit account #
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Renetta
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.
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.
R
Renetta
Additional info. 26 sub funds nested with in many of those 9 digit accounts
that payments are received for.
that payments are received for.
R
Rick Brandt
Renetta said: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.