building an array?

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

I need to combine sets of records into one record for
export. The number of records is variable (up to 100).
This is for a Bill of Material table. The record needs to
look like... AssemNumber PartNumber1 Qty1 PartNumber2
Qty2.... ect.

Thanks!!!
 
You're going to need to do this in code, I think. Try something like

Dim rs as Recordset
Set rs = <whatever>

dim recString as String

Do while not rs.eof
recString = recString & rs.PartNo & " " & rs.Qty
loop

But that's very rough, as I don't know what queries or tables you're using.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...
 
Back
Top