Careat report with using data of each employee from 2 tables

's Computer Specifications

I want to create report for employes courses . So it display the courses that
employee pass them and the courses that employee not yet pass them. the
courses that passed is in table and the courses that not yet assed is in
another table. the report will be grouping by employee number.
Please help me to do it.
Tks

's Computer Specifications

you must combine the two tables into one table.

employee, courseName, passed

passed will be a logical field (true,false) or could contain "passed"/"not
passed"

After this is done than you report can Group on employee, then passed

"Hamoud Alrashid" wrote:

> I want to create report for employes courses . So it display the courses that
> employee pass them and the courses that employee not yet pass them. the
> courses that passed is in table and the courses that not yet assed is in
> another table. the report will be grouping by employee number.
> Please help me to do it.
> Tks

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting another employee's data from the Employee table, and text innumber fields	Lostguy	Microsoft Access	3	27th Nov 2008 05:40 AM
how do i add a employee picture to an employee table?	=?Utf-8?B?Um9iZXJ0?=	Microsoft Access	3	18th May 2006 07:59 AM
Calculate employee hours for employee evaluation?	Triesha	Microsoft Excel Worksheet Functions	3	9th Feb 2006 03:52 PM
Return employee name when the employee's number is entered	=?Utf-8?B?TWlrZQ==?=	Microsoft Excel Worksheet Functions	1	16th Sep 2005 07:28 PM
Fromula to take employee # out of employee name field	mikeburg	Microsoft Excel Misc	9	12th Sep 2005 03:41 AM