This may be a lot easier than it appears to be but I need a little help getting started.

I am creating a roster from two tables.

Table 1 has two fields I would like to use [Rank] and [LName]
Table 2 has one field I would like to use [Nomenclature]

What I would like to do is take the two fields from Table 1 and maker the Row Headings and the one from Table 2 and make it Column Headings
...