Concatenating from a table or query.

[stephen c]

Hello, all.

This should be simlple, but isnt'. My database uses a query to constrain information used in all of it's reports. The user chooses what "buildings" he or she wants included in the reports. Those choices are accumulated into a query with only one field...BUILDING.

The problem is that nowhere on the form do the reports say "This report is for buildings x, y, z."

Let's make it easier, and say that these selections create a table which contains only one field...BUILDINGS, where there is a record for each building selected.

How do I get a concatenated field that shows which buildings are contained in the table?

This seems easy. In EXCEL, the buildings would be in A1, A2, A3, and it would just be concatenate(A1,A2,A3).

I am very much a newbie, who has tought himself how to use access for the purpose of this database. Over the last two weeks. As such, I'm logically fairly adept, but not versed in VB at all.

Many thanks in advance.

Stephen.

[RuralGuy]

You could pass this information to the report in the OpenArgs argument of the OpenReport command.

[stephen c]

I hope not to sound like a jerk with this answer, but I predicated the question with the statement that I'm a newbie. As such, I do need a wee bit more direction.

Thanks!

[RuralGuy]

The OpenArgs parameter of the OpenReport command is a string value. Are you running the report directly from your form? If so, do you use code or a macro? If code then could you post the procedure starting with Private?