reports like as preadsheet

[56th Rowallan]

Hi All

i realise this may be a daft question but i need to create a report which lists grouped by name modules completed ie:

Name Modules completed
Fred Bloggs Module 1 Module 2 Module 3
Jim Smith Module 1 Module 2 Module 4

the names aRe held in one table/ form (Leader records) and the training modules completed in another table/form

Heeeeeellllllp

Many thanks

Row

 

[GohDiamond]

Create the Query that connects the tables:
MyNames_tbl and MyModules_tbl
List all names with a unique NameID for each record in MyNames_tbl
List all modules with a unique ModuleID for each record in MyModules_tbl

MyModules_tbl must have a foreign key NameID associated with each record as well.

MyNames_tbl.NameID = MyModules_tbl.NameID

Runing the query will create a datasheet type result that you can just print out sorted by NameID. If you want to get more elaborate then use that query result to create a Report.

Hope that helps,

Goh