Trying to Group several records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top