Summary field on a report

[imstuck]

I have a report based on two tables with a one to many relationship. For each id in table 1, I need to have one field that will summarize a particular field from all the records in table 2 for that id.

Example:

ID 1 1990, 1995, 1997
ID 2 1978, 1981

etc.

What's the best way to do this?

Thanks- [sig][/sig]

 

[phparadis]

I believe the easiest way to approach this is to build a query using the two tables with the link between the primary key in table 1 and the foreign key in table 2. Use this query and the report wizard to generate the report. The report wizard will give you the option to creat a summary line based on the primary key from table 1 and give you sub totals. [sig][/sig]

 

[imstuck]

Perhaps I shouldn't have used the term summarize. I need to list the years, not perform a math function on them. I don't believe the report wizard allows for that.

Thanks anyways--anyone else have any other ideas? [sig][/sig]