is an 'if then' needed?

[fatdog302]

Hi all,

want to output this:

Title FirstName LastName Crane Forklift Member
MR Colin Citizen YES YES YES
MR Peter Smith YES
MS PENNY Wilson YES


I have a candidate table(which has all the candidates deatils), a skills table (which contains all the skill such as crane, forklift and member)and and a table that links the two as it is a many to many.

There are no fields in the database called crane, forklift or member these are records in the skills table. so how do i create these as comlumns of my results and then assign a yes to it if indeed the candidate does have that skill linked to them.

 

[mrdenny]

This is called a cross tab query. There are several examples if you search the forum. donutman has also written some excellent FAQs on them. Part 1 is faq183-5269, and Part 2 is faq183-5278.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)