Concatenating Fields

[Leo]

What is the easiest way to achieve this in a query (or through code)

How it is right now

Field1
1/2/2004
Not in stock
2/4/2004
Not in stock
3/4/2004
Avaliable
1/12/2004
Not in Stock
etc......


How i would like to show it

Field1 Field2
1/2/2004 Not in Stock
2/4/2004 Not in Stock
3/4/2004 Available
1/12/2004 Not in Stock....etc

So basically for each second field I'd like to have it move besides the
field right above it in a new column rather than be in a record below it

Is there an (available) solution to this problem?

Thanks a lot for your time

Leo

 

[Rebecca Riordan]

You can do this in an update query, and I recommend that you only do it
once...the format that you're working with is incorrect, and is going to
cause you no end of problems in the long-run

hth

--
Rebecca Riordan, MVP

Seeing Data: Designing User Interfaces
Designing Relational Database Systems, 2nd Edition
www.awprofessional.com

Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step
www.microsoft.com/mspress