Report Question

[Guest]

I have a list of accounts, each account is classified by a type and each
account has a dollar value associated with it. I need to group each account
by the following criteria:
0-25 Name Type Dollar
25-100 Mike C 25
101-500 Joe C 150
501-4000 Luke A 5000
4001-1000

What I need to do is create a report that will break down the list of
accounts by type and then by dollar value?

I can run a query that will give me the result I need one at a time, but
that will be time consuming. I want to be able to do it all in one shot.
Please help.

Thank you

 

[Joseph Meehan]

I have a list of accounts, each account is classified by a type and
each account has a dollar value associated with it. I need to group
each account by the following criteria:
0-25 Name Type Dollar
25-100 Mike C 25
101-500 Joe C 150
501-4000 Luke A 5000
4001-1000

What I need to do is create a report that will break down the list of
accounts by type and then by dollar value?

I can run a query that will give me the result I need one at a time,
but that will be time consuming. I want to be able to do it all in
one shot. Please help.

Thank you

Sorry, but from your example I am not sure what your data is like and what
you want. If I guess right, you can do what you want, but I am not at all
sure if I am understanding you right.

Do you want to group the data by the dollar amount? Then you could
create a query that would have a dynamic field and us an IIF statement to
proved a maybe a A=0-25 B=26-100 etc. (BTW don't use 25 twice.

Then you could group the data based on that new field.

 

[Guest]

No, you guessed right. I will be sorting the accounts by dollar group first,
then by type. But exactly how would I get a total number of accounts that
have the dollar value from 0-25, etc. and then group them by type?

 

[Joseph Meehan]

No, you guessed right. I will be sorting the accounts by dollar group
first, then by type. But exactly how would I get a total number of
accounts that have the dollar value from 0-25, etc. and then group
them by type?

It may not be the best way, but I think I would use a query and a
calculated field. Use a nested iif statement and do a IIF FIELDNAME >0 and
<26 A

Then group on that new calculated field.