Query view

[Chris]

This is kind of complicated to describe and I don't know if it's possible to
implement.

basically a staff member can have many tasks, I've linked my tables and a
simple query works displaying the data like this;

Staff Task
----- ------
John Smith Analyse program
John smith design Program
john Smith Implement program
john Smith Test program
Joe Bloggs Network Support
Joe Bloggs Test program
Mary Jones clean PC's
Mary Jones Defrag hard drives
Mary Jones Analyse program

I would like the output to be in a listbox, but, any output like this would
be great ;

Staff Task 1 Task2
Task3 Task4
John Smith Analyse program Design program Implement program
Test Program
Joe Bloggs network Support Test program
Mary Jones Clean Pc's Defrag hard drives Analyse program

Is it possible?

Could someone tell me how please?

 

[Joan Wild]

Staff Task 1 Task2
Task3 Task4
John Smith Analyse program Design program Implement
program Test Program
Joe Bloggs network Support Test program
Mary Jones Clean Pc's Defrag hard drives Analyse
program

Have a look at http://www.mvps.org/access/modules/mdl0004.htm