linearize data

[Question Boy]

I hope I can explain my issue properly.

I have 2 tables

Table 1 - tbl_employees
EmpId
Name
FamilyName
....

Table 2 - tbl_skills
EmpId
Skill
ProfLevel

As such, each employee can have 1 or more skills. When I create a query to
return a list of skill by employee it is setup like
EmpId Name FamilyName Skill ProfLevel
1 John Smith Computers 3
1 John Smith Administration 2
1 John Smith First Aid 1
....

How can a create a query to return the results like
EmpID Name Family Name Computers Admin FirstAid
1 John Smith 3 2 1


Thank you in advance,

QB

 

[John W. Vinson]

How can a create a query to return the results like
EmpID Name Family Name Computers Admin FirstAid
1 John Smith 3 2 1

By using the Crosstab Query wizard.

Use EmpID, [Name] and [Family Name] as the Row Header fields, and [Skill] as
the column header.

 

[BrianP]

John,

Following the same train of thought as QuestionBoy, I have annual
transaction history table whereby the data is similarly columnar. It lists
all customer billing transaction details by date such as:

Acct Invoice BillDate Amt
123 98765 1/15/08 10.00
123 98765 2/15/08 10.00
123 98765 3/15/08 10.00

What I need is to append/write the data to a new table that shows the
transactions linearly such as:

Acct JanInv JanBill JanAmt FebInv FebBill FebAmt MarInv MarBill
MarAmt
123 98765 1/15/08 10.00 98765 1/15/08 10.00 98765 1/15/08
10.00

Can this be done through a crosstab? If not, any suggestions would be
greatly appreciated.
Thanks.
BP

How can a create a query to return the results like
EmpID Name Family Name Computers Admin FirstAid
1 John Smith 3 2 1

By using the Crosstab Query wizard.

Use EmpID, [Name] and [Family Name] as the Row Header fields, and [Skill] as
the column header.