Query on two fields in one table

[phillbaker]

i have a table setup in a database to store information on a clients training. They want to store 2 lots of training information. So i have setup to colums within the table as below

e.g

Training
Training 2

In these colums its storing that they are either doing training or seeking training.

I want to be able to filter out on both colums those people that are doing training. But if i put in the expression "training" on both the training and training 2 column its showing me only the results for the first column training and all everything else in the training 2 column.

is there any easier way around this.

phill

 

[Rabbie]

Read up on Data Normalisation. You shouldn't dupplicate fields in a table. What is going to happen when they decide they need 3 items of training or four etc.

In a relational database like Access you should have a client table, a training table and a junction table linking Clients and Training. This is because a client can go on several training courses and a course can have more than 1 client attending.

Thes links may give you a good starting point.

http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx
http://www.datamodel.org/NormalizationRules.html
http://allenbrowne.com/tips.html
http://www.btabdevelopment.com

Hope these help

 

[phillbaker]

thank you for your reply. this is one thing i did think about at the start how ever with the specification i was given. They just wanted to list they where training as an option in a list box but not going to any detail like you have suggested about one person on many courses etc.

thank you for the links also this is a great help