count or sum?

[mcraven]

I have two tables - one is the inventor name, one is the #patents and the business unit. (in a nutshell - these are the only fields I need from each)

I need a query to return the results:

Inventor Name #Patents BU

Joe Smith 28 W
Joe Smith 4 F

what I get is:

Joe Smith 1 W.....(28 times in a column)
Joe Smith 1 F...(4 times in a column)

I've read and studied and queried and tested until I can't see. This can't be that hard. Can someone help?

 

[Moniker]

You want a GROUP BY. Turn on aggregate queries (the sigma in the query design toolbar) and the group by will handle at least the example you've provided.

 

[mcraven]

Count or Sum?

Created a simple query - put group by in the TOTAL area - got back a list, sorted by name, then business unit. I can see that Mr. Jones has 5 if I count them, but I want the result to be:

Mr. Jones 5

not

Mr. Jones
Mr. Jones
Mr. Jones
Mr. Jones
Mr. Jones

 

[Moniker]

On field one, GROUP BY on the person's name.
On field two, COUNT on the person's name.