Access Concatenate rows into single rows: extra conditions needed

Question

I'm working with an Access database and I need to concatenate different related rows into 1 row. I found a solution here and used it with great success. However I need to add extra conditions to it, it should only be done if certain other columns are equal too. For example:

1 X Alpha

2 Y Beta

1 X Gamma

1 Z Delta

should become

1 X Alpha,Gamma

1 Z Delta

2 Y Beta

Does anyone know to do this, especially for a newbie like me?

Answer 1

It seems you are using the code supplied in http://stackoverflow.com/questions/230241/does-ms-access2003-have-anything-comparable-to-stored-procedure-i-want-to-run.

There is no reason why you should not feed in two fields as one in your sql, so an example:

SELECT Number & Letter,
Concatenate("SELECT Letter & Alpha As FirstField FROM tblTable
     WHERE Number & Letter =""" & [Number] & [Letter] & """") as FirstFields
FROM tblT

Answer 2

Thanks a lot!!! Works like a charm. I had never imagined the solution would be so simple.