adding 3 different textboxes into one field of access

[peter11]

I have 3 text boxes on a input page but I want the info from all 3 entered in the same field of an access database.

Is this possible?

 

[CFDude]

Sure, to make it easier to read, you can concatenate the 3 into a variable first then set it e.g.

<cfset all3vars = &quot;#form.field1# #form.field2# #form.field3#&quot;>

<cfquery name=&quot;foo&quot; datasource=&quot;myDsn&quot;>
Insert into MyTable(FieldtoInsertTo)
Values('#all3vars#')
</cfquery>

or you can simply do:

<cfquery name=&quot;foo&quot; datasource=&quot;myDsn&quot;>
Insert into MyTable(FieldtoInsertTo)
Values('#form.field1# #form.field2# #form.field3#')
</cfquery>

(notice that you put only one set of single quotes around all 3 form vars. (I'm assuming these are all text fields, otherwise you wouldn't use the quotes)