How to create roster for list of Members and Items

[Brilstern]

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

I know this sounds like a cross tab query but I want to be able to fill in this roster essentially with tallys every time someone purchases something under that nomenclature.

below is a basic idea of what I am looking to do.

                    Milk      Gatorade Soda    Coffee Muscle Milk
Sgt Jones            1        2        0        3        1
Sgt Jane             1        2        6        0        2
Cpl Smuck            0        0        2        1        0
LCpl Mason           5        1        2        2        0
 
...
 

[Rabbit]

There's not nearly enough information to answer this question. For one thing, I don't see anything that links table 1 to table 2. And we would need to know the structure and at least some sample data from each table.

[Paulo357]

You're starting at the end product. You first need a Table to hold the purchases. It will need to hold the ID of the individuals and ID of the Products and anything else you want to report on like date? or Value?. You then need to create a Form to capture the purchases by individuals. Use combo boxes to get Names & Products from the respective Tables