Query help

[dgmorr]

Hey guys,

I'm not too sure how to describe this, but here's a stab at it. I have a list of ID's which contain a few duplicates. I want to make a query that concat's all the ID's and show the non-similar data in a separate column. Something like...

ID || Name

1 || 1

1 || 2

1 || 3

1 || 4

1 || 5

1 || 6

1 || 7



And show



ID || Name

1 || 1,2,3,4,5,6,7

 

[pbaldy]

Numerous ways, here's one:

http://support.microsoft.com/kb/210163/en-us

 

[dgmorr]

I'm having trouble getting that one to work.

'Objecto does not support this property or method'

pointing to

Me!AllProducts = Null

 

[boblarson]

Try using
Me!AllProducts = ""

instead of null.

You could also try IsNull(Me!AllProducts)=True

 

[dgmorr]

Try using
Me!AllProducts = ""

instead of null.

You could also try IsNull(Me!AllProducts)=True

Me!AllProducts = "" came up with the same error as above


IsNull(Me!AllProducts)=True
returned....

Function call on left-hand side of assignment must return Variant or Object.

Ahhh, I thought this was going to be a simple query.