concatenate

[stephenaa5]

Hi. Need to concatenate the data in a given field of a continuous form, IF another field of the same record (which is a Y/N) is equal to Y. That data will be put in a holding control "TITLEBLOCK" used on subsequent reports, to state in the header what data is included.



So, the form is "Selector". The Y/N is "include" and the field is "building". Here's a quick and dirty:

Include building
Y site 1
Y site 2
N site 3

TITLEBLOCK would be "site 1, site 2"

Any help is appreciated. My VB knowledge is pretty light, particularly where looping is concerned. I'm thinking that's what's needed here.

Thanks,

SC

[TheShabz]

i dont think you're looking to concatenate persay. Are you trying to get a table that looks like:
Include building
Y site 1
Y site 2
N site 3

into one tha tlooks like
Include building
Y site 1 site 2
N site 3

if so, look up the crosstab query. that should help you out. no vba necessary (unless its within a larger framework, then just save it as a sql string and run it).

[pbaldy]

I suspect you want something along these lines:

Return a concatenated list of sub-record values

http://allenbrowne.com/func-concat.html

customized to restrict records to the Y and whatever criteria restricts the subform.