List of Suppliers

[Cummings]

Hi.

I'm trying to create a report that lists each of my suppliers. Once. And
provide a count of the different ones. This is a very simple report. That's
it.

Most suppliers provide more than one item, so I found how to not print the
duplicate entries, but it insists on printing the blank lines for each of the
duplicates. I did select "allow to shrink". And, the count reflects the
total number of entries (blank lines for duplicates included).

Any assistance will be appreciated.

Thanks

Jim

 

[Tom Lake]

Hi.

I'm trying to create a report that lists each of my suppliers. Once. And
provide a count of the different ones. This is a very simple report.
That's
it.

Most suppliers provide more than one item, so I found how to not print the
duplicate entries, but it insists on printing the blank lines for each of
the
duplicates. I did select "allow to shrink". And, the count reflects the
total number of entries (blank lines for duplicates included).

Any assistance will be appreciated.

If your database is properly designed, you should have a suppliers table
with
just suppliers in it, one per record and no duplicates. Use that table for
your
query. If you only have a table that has the supplier info (name, address,
phone,
etc.) listed with each item that supplier carries, you need to normalize
your
tables.

Tom Lake

 

[Cummings]

Thanks. But . . . .

What I really have is a listing of technologies with some suppliers
providing more than one. So, it's really the technologies that are
important, and not the suppliers.

Jim

 

[Larry Linson]

What I really have is a listing of technologies with some suppliers
providing more than one. So, it's really the technologies that are
important, and not the suppliers.

And, you still haven't said how you've laid out your tables, and the
contents of those tables.

If you have the supplier information in multiple technology records, not in
a related supplier table, then you have redundant data. It's possible, I
suspect, to accomplish what you want even so, but it will be done
differently than if you have properly-designed, normalized relational
tables, and we really need to know what you have done before we can help you
with how to do it.

There are some people here who are pretty good with Access, but not very
many people with the ability to correctly _guess_ how you constructed your
database.

Larry Linson
Microsoft Access MVP

 

[Cummings]

I'm sorry, but it really is simple.

One sheet.

Column 1 is the unique identifier
Column 2 identifies the iteration of the experiment (I know how to filter
out the unwanted years)
Column 3 identifies the Technology name
Column 4 identifies the supplier
Rest of the columns have things like contact info for the technologies,
anticipated costs, etc.

Like I said, really simple.

Thanks

Jim

 

[A Man]

I'm sorry, but it really is simple.

One sheet.

Column 1 is the unique identifier
Column 2 identifies the iteration of the experiment (I know how to filter
out the unwanted years)
Column 3 identifies the Technology name
Column 4 identifies the supplier
Rest of the columns have things like contact info for the technologies,
anticipated costs, etc.

Like I said, really simple.

This looks like the layout for the report you want. We really need the
layout for *all* tables the report is based on. That is the only way we
can help you.

If indeed the above is the table layout, you need, in your report, to
make a group on Supplier. The default options for the Supplier group
should remove unwanted dupes.(In Acc2000 it is under View, Sorting and
Grouping.) Sort Ascending in the Group Dialog.

Preview your report.



Chuck