Skills list (variable)

[Gerry White - use my name at dergal dot come for e]

Ok, I am sure that this is dead easy, but I am curious as to how processor
hungry this is...

Basically I am doing a large database of people which has a list of skills
attached to each person, they will be entering this and unfortunately each
skill can be different - i.e. person 1 has
ASP 2 years
CSS 5 years
HTML 6 years

but person 2 has
HTML 3 years
PHP 2 years
..NET 1 years

Now, the way I would have thought would be to use related fields, i..e

Person -
Skill -
Level -

I was wondering how easy it would be to run searchs off this afterwards (in
terms of processor power...)

Cheers Gerry

 

[Michel Walsh]

Hi,


I would say that this is relatively minimal... hard disk access would be
more important.


For the SQL statement, see
http://www.mvps.org/access/queries/qry0016.htm


Hoping it may help,
Vanderghast, Access MVP

 

[Gerry White - use my name at dergal dot come for e]

Hi,


I would say that this is relatively minimal... hard disk access would be
more important.


For the SQL statement, see
http://www.mvps.org/access/queries/qry0016.htm

Superb, I thought that was the way to go, but I have read so much on
optimistation, and not to normalise too far, and ... well my heads
swimming... Thanks, btw whats MVP ?

Gerry

 

[Michel Walsh]

Hi,


MVP is a Microsoft award ... It stands for Most Valuable Professional, and
you may get more info at their page:


Vanderghast, Access MVP