>I have a table called subject with three fields of the same datatype.
>how I can append all these records from the table subject to another new table in one field only.
>
>any help
>thank you
You must write a loop that processes each record three times.
However, you should be aware that situations where three different fields have the same type of information should normally be avoided, precisely because processing it is more complicated.
The data should (normally) go to a separate table, with one record for each piece of data.
If you tell me what kind of data you store, I might give you more specific advice.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)