Count records within range

[Steven R via AccessMonster.com]

Duane gave me the code within a separate column of my queries to count
records that are under 5,000:

=Sum(Abs([sumofnetvalue]<5000))

.... how would I create another similar column that would count the number of
records that were between $5,000 and $10,000 ?

 

[Duane Hookom]

=Sum(Abs([sumofnetvalue] Between 5000 and 10000))

However, before you hard-code lots of these expressions into
queries/reports,... you might consider what kind of effort it will take WHEN
your pointed-haired-boss says "Now I want to see 0-4000, 4000-8000,
8000-15000,..."

 

[Steven R via AccessMonster.com]

*LOL*
Actually, my boss got fired today, and I'm a contractor ! Not looking too
good for me - I may get the dreaded phone call...

Thanks for your help !
Steve

=Sum(Abs([sumofnetvalue] Between 5000 and 10000))

However, before you hard-code lots of these expressions into
queries/reports,... you might consider what kind of effort it will take WHEN
your pointed-haired-boss says "Now I want to see 0-4000, 4000-8000,
8000-15000,..."

Duane gave me the code within a separate column of my queries to count
records that are under 5,000:

[quoted text clipped - 4 lines]

of
records that were between $5,000 and $10,000 ?

 

[Duane Hookom]

Didn't mean to make trouble for him :-0.

--
Duane Hookom
MS Access MVP
--

*LOL*
Actually, my boss got fired today, and I'm a contractor ! Not looking too
good for me - I may get the dreaded phone call...

Thanks for your help !
Steve

=Sum(Abs([sumofnetvalue] Between 5000 and 10000))

However, before you hard-code lots of these expressions into
queries/reports,... you might consider what kind of effort it will take
WHEN
your pointed-haired-boss says "Now I want to see 0-4000, 4000-8000,
8000-15000,..."

Duane gave me the code within a separate column of my queries to count
records that are under 5,000:

[quoted text clipped - 4 lines]

of
records that were between $5,000 and $10,000 ?