Array?For Each? Transpose.....

[dtaylor]

Hello All,
Is this possible?......

I have a table that is grouped by customer number and contract number. For each customer there can be from 0 - 10 contracts -so because of the contracts there are multiple customer number entries.

What I am trying to do is create a table that has a single customer line and each of the grouped contracts as a field on the same line - contract field 1, 2 , 3 ect???

An array? For Each? Is this too much to ask? Any suggestions, links, tidbits to get on the right direction....

Thanks

Dan

 

[dtaylor]

Russell,
You are great! Works like a charm...
When you said I had empty strings it hit me - I created the field names on the fly withing the query - so of course it came over a empty strings.

All this because I tried to take a shortcut!

Thank You!

Dan

 

[Russell Hauf]

Yeah, that's what I thought. That was actually nice work on your part. You could also change the code from IsNull(xyz) to If xyz = ""...but I was lazy.

Glad it worked,

Russell