Ordered report (1 Viewer)

[SeeAll]

Hi,
I wish to combine data from two tables into a report.

Table 1
Name Year
Abbott 1653
Andrews 1653

Table 2
Name Year
Abbott 1700
Andrews 1700

Report
Name Year
Abbott 1653; 1700
Andrews 1653; 1700

I hope the above makes sense? Using MS Access 2007.

Help! I'm sure there's a simple solution.

 

[theDBguy]

Have you tried creating a query for your report? For example, create something like:

SELECT Table1.[Name], Table1.[Year], Table2.[Year]
FROM Table1 INNER JOIN Table2
ON Table1.[Name]=Table2.[Name]

If you really want to combine all the years in a single column, you can take a look at this simple function.
http://www.accessmvp.com/thedbguy/codes.php?title=simplecsv
Hope that helps...

 

[Pat Hartman]

You may want a union query. It is not clear if you want a list that includes items from all there tables or if you want to join the tables and display records that match.