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]
Example:
ID 1 1990, 1995, 1997
ID 2 1978, 1981
etc.
What's the best way to do this?
Thanks- [sig][/sig]