Best Practice for Developing a Grid

[Lance]

Hello,

I am looking for the best method to create a displayable grid out of a
table of data.

I essentially have three tables. one with Student information, one with
report information, and one with student's turning in their reports.
The report names are tblStudent, tblReport, tblPortfolio, respectively.

The question is how do I get the data from tblPortfolio, to print out
as a grid, including everyone from tblStudent, and everything from
tblReport, so that I can get output that shows the x and y axis with
all applicable data, and then some sort of either symbol, or entry from
another field, to show up in the actual "square" on the grid to show
the data point exists.

I hope I have explained myself clearly, but if not, I can answer any
follow up question. I don't expect to have someone answer the question
of how to do it, I just need someone to point me in the right direction
for getting this done.

Thanks,

Lance

 

[Ed Robichaud]

You haven't explained what your tblReport records contain or how they're
related, but try one of the below:

Pivot Chart form wizard. Make a query that combines the data you need, then
follow the wizard prompts to create a chart/grid with studentID/Names on one
axis and probably a date range on the other, with the related tblReport
value summarized in the middle.

Cross-tabulation query wizard. Same initial process as above.
-Ed

 

[Lance]

Perhaps I should explain myself a bit more clearly.

In tblStudent, the table just includes all relevant student
information. In tblReport, all that it houses it the name of the report
(For example, one datapoint is Internship Report). There are ~15
reports housed in this table, all with a unique ReportID, and
ReportName.

In tblPortfolio, there are 4 fields. StudentID, ReportID, Comment,
RecDate

Where student ID is the relevant ID, reportID links to the proper
report, comment allows the user to place a comment about the report
being received, and RecDate provides the date it was received.

What I would like to do is make it so that I can create a datasheet, so
that ALL relevant students from tblStudent are listed in rows, and ALL
relevant reports from tblReport are listed in columns. Then I would
like some sort of indication at Row X, Column Y, that shows the given
report exists in tblPortfolio.