Sammensætning af data fra flere felter

Nej

YES!
Schulze, are you saying that I cant insert the values from three fields into a fourth field? THats no problem!

Terry>When it´s a mix of text and values?

kan man ikke lave en forespørgsel hvor man kæder felterne sammen?????

Næh.

Altså man kan selvfølgelig godt i en ny tabel, men det er jo ikke det toke ønsker.

Men det er da underligt terry ikke beskriver hvordan man gør.

schultze>I see NOTHING which says the values are numeric or text, and even if they were what is the problem? Does he want to ADD the values togther OR just concatenate them?

In the BEFORE update even for the form.

Me.FourthField = Me.FirstField & Me.SecondField & me.ThirdField
and if that doesnt work we can start using
CStr() Or NZ() or any other fucntions which may be necessary to "sammensætte" the values!

Is that a problem or what schulze?

But we are talking about tablefields not forms. So I can't really see how.

schulze>Come on! We know that the data is going into a table, but normally we enter data through a form dont we? and even ín an ASP program this would be possible!