Concatenate fields

[redbay]

How can i concatenate first name and last name fields in dreamweaver. please

 

[dodge20]

For asp

select FirstName + ' ' + LastName as FullName from Customers

Dodge20

 

[redbay]

Where do i put this i, tried it in the advanced section of the recordset and it didnt like any of it?

 

[dodge20]

That is the asp code, you will have to find your select statement in the code section and format it something like i posted above.

Dodge20

 

[lebisol]

why not use the database to do to work?
make a querry and compund the fileds in it...
QRY
-------
Compund: Table![FirstName] & " " & Table![LastName]
-------

then simply pull the querry as another 'table view'
mostarnet.com/tutorials/access/compund.zip


if u care only to have it displayed on page as compund then use what dodge20 said....or simply drag and drop firstname lastname field from recordset

if ur looking to do some more qurries and what not then I say make your DB do the work vs. page
All the best!

:--------------------------------------------------------------------------:

All around in my home town,
They tryin' to track me down...