Multiple Values In Table

[Imy South]

I am a new user of Access 2000 and I have come across a few problems. Please if anyone can help reply I need your help urgently........

Town's you have visited

Manchester
London
Liverpool
Newcastle
Huddersfield

I want to select 3 town's above and store the data into the field (visited town's) How do I do this???

2)I have a list box on a form and i want to be able to select more that one value and store it into a field, how do I do this?

3) Last but not least. I have a text field that calculates from a different feild, but when it calculates it doesn't store the result into the field, it leaves it blank........

Thank you...........

 

[Mile-O]

1) I want to select 3 town's above and store the data into the field (visited town's) How do I do this???

Use have a one to many relationship and require a form with a subform.

2)I have a list box on a form and i want to be able to select more that one value and store it into a field, how do I do this?

See 1.

3) Last but not least. I have a text field that calculates from a different feild, but when it calculates it doesn't store the result into the field, it leaves it blank........

The fact that you can calculate it from what's on a form means that you don't need to store it in the table. Remove the field from your table; it's unnecessary.

Do: do search on normalisation.

 

[Mile-O]

Imy South: Please keep your questions to the forum. That's why it's here.

Also, read this