Hello I have the lotus notes sql driver connected to an access
database.

I have all the data linked to a table in access.

I was wondering how to create a vendor performance report like the
following



Supplier Received Lots Rejected Lots Accepted
Lots

Supplier A 4 4
Supplier B 5 1 4


The Supplier A in the example has 4 records. That is what the four
received lots are for.

Access shows the supplier name 4 times.

How can I get it to "Categorize" the supplier name (like in above
example )and get it to count the records for each to produce the
recieved lots column.

The rejected lots column should come from the record. There is a
field in the table for Rejected or Accepted.

The Accepted Lots column would be (Received Lots - Rejected Lots)

Can Access create this kind of report?

Thanks for any help in advance.

kennethgrice (AT) yahoo (DOT) com (Kenneth Grice) wrote in message news:<e2a8f3b4.0405041040.6ebf321c (AT) posting (DOT) google.com>...
You should be able to use a count function with a group by clause. If
you want to E-mail the table I can take a look at it. We sell a
reporting tool that you might also find useful, called Super*SQL. It
will cost $20 but if you want to be part of the Phase II Beta testing
program you will get a copy for free.