Trouble with subdatasheet

[Guest]

I am trying to get Access to show a list of employees with a subdatasheet
under each name showing their QA scores but can not seen to get it right. I
have data on every employee broken down by months showing the employees QA
score in Excel. There is about 7 catagories that each employee is grded on
each month. I can get the data from Excel to Access with no problem but can
not get it to display the way that I want it. I would like to open a list of
each employee and under their name have the QA scores listed by month so the
supervisors and employees can see how they are doing. I am going to add more
data to the display later but right now just can not get the information to
display. I ahve tried forms and queries but can not get all the data to
display. Is there a way to display all the data for the employee?

 

[Jeff Boyce]

First, it sounds like you're working directly in the table. Don't. Access
tables are "buckets 'o data". Access forms (and reports) are used to
display data.

I don't have a clear picture of your underlying data structure. Since how
you'd display data depends on how it's organized, consider posting a brief
description of your table structure.

If you want a way to select an employee from a list and see that employee's
QA scores, consider creating an unbound form. Add a combo box in which you
select the employee. Add a listbox based on a query that uses the combo box
as a criterion for which employee. Do whatever aggregation and sorting you
need to in that query that you use to feed your listbox.

Then, in the "Select employee" combo box's AfterUpdate event, add in code to
requery the listbox -- something like:

Me.lstYourListBox.Requey

Regards

Jeff Boyce
Microsoft Office/Access MVP