Trying to Group several records

D

Database Novice

I'm not sure if what I want should be done in a query or a report...I have
two tables (one with names of who gave stock and one with the actual sales of
the stock). It is a one to many relationship. I want to generate a report
that will show the name of the giver and the total that they have given. I'm
not sure how to do it. Thanks.

Table 1:
John Smith

Table 2
IBM 50 shares
IBM 25 shares
IBM 22 shares
IBM 10 shares
 
K

KARL DEWEY

I do not see any relations between WHO GAVE and ACTUAL SALES.

If you included the stock name of the giver then you would have a relation
on stock name.

OR maybe you omitted a lot of fields from your table data.
 

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