By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 838 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

How to create roster for list of Members and Items

P: 207
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.

Expand|Select|Wrap|Line Numbers
  1.                     Milk      Gatorade Soda    Coffee Muscle Milk
  2. Sgt Jones            1        2        0        3        1
  3. Sgt Jane             1        2        6        0        2
  4. Cpl Smuck            0        0        2        1        0
  5. LCpl Mason           5        1        2        2        0
  7. ...
May 31 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 12,357
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.
May 31 '12 #2

P: 18
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
Jun 3 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.