count multiple records as one / in groups

J

JK

I have a db with Customers and each customer has a Product Profile (item,
item desc. etc) All items and account information are in the same table
(unfortunately - I have this db linked to J.D. Edwards using an ODBC driver).
Which means if an account has two items in their product profile, the account
name and acct number are listed 2 times.

I have a report grouped & sorted first by Salesperson and then by Class of
Trade.

I want the report to display the Salesperson's name - then all of that
Salesperson's accounts (with each item under each acct name) grouped and
sorted by Class of Trade.

I need to count the number of accounts in each class.
And, I need to count the number of items in each account profile (or in each
class) with a total number of items (per class) displayed at the end of each
Class Group - with a grand summary at the end of the report.

Maybe someone could point me in the right direction?

Thx.

I thought I could do all of this counting inside the report - but maybe
that's not the case?
 
J

Jeff Boyce

Without seeing the SQL statement you are using, it's a little tough to offer
specific suggestions.

Have you tried creating a query that only gets UNIQUE acct#s? Create a
query against the table, add the Account# field, then change the UniqueValue
property to Yes.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
J

JK

That's a really cool function that I never would have found.
So I'm assuming if I use that qry in place of the main table from now on -
most of my problems will be eliminated.

I'm still working on the report. I'm so close now trying to go around the
multiple name/number issue that I'd rather not start all over. I guess if I
have to - I'll have to.

Thank you so much. You've been a huge help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top