String data from numerous records

[savadi88]

Hi all,
I have an issue printing a report.

I have a report that groups on field1. I print fields 2 and 3 and count of
field1. No problem so far. However, I also need to print a string of field4
for the group. For example, given the following data

field1 field2 field3 field4
1 f12 f13 f14
1 f22 f23 f24
2 f32 f33 f34
3 f42 f43 f44

should print where col3 is the string of field4 and col4 is the count of
field1

col1 col2 col3 col4
f12 f13 f14;f24 2
f32 f33 f34 1
f42 f43 f44 1

How do I string together data from field4 to print in col3? I can string
together the data with the GroupFooter0_Format event but it prints everthing
in col3 for every row. I know I need to clear the string somehow but can't
seem to figure it out. I really apprecaite any help.

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[savadi88]

Duane,
Thanks for the reply. I looked at your example but I was hoping the report
would be able to string values together with the _format or _print events (or
whatever) instead of doing a seperate select for the field. Thanks for your
help.
--
Thanks in advance
Savadi88

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[savadi88]

Also,
I tried your solution and it's doing the same thing as mine, it's printing
everything in col3 in every row. I can print out that using the
GroupFooter0_Format event but I'm not able to clear out the textbox (which
I'm using to display col3) when a new group starts. Any more help is greatly
appreciated.
--
Thanks in advance
Savadi88

Duane,
Thanks for the reply. I looked at your example but I was hoping the report
would be able to string values together with the _format or _print events (or
whatever) instead of doing a seperate select for the field. Thanks for your
help.

 

[Duane Hookom]

Don't include Field4 in your report's record source and group by Fields 1,
2, & 3.

 

[savadi88]

Anyone have any suggestions? Thanks.

 

[Duane Hookom]

Did you read my reply from 8/15?

 

[savadi88]

Duane,
Yes I read it and replied.

"I tried your solution and it's doing the same thing as mine, it's printing
everything in col3 in every row. I can print out that using the
GroupFooter0_Format event but I'm not able to clear out the textbox (which
I'm using to display col3) when a new group starts. Any more help is greatly
appreciated."

Unfortunatly, it did not help, unless I'm missing something. Thanks for any
more help.

Tom

 

[Duane Hookom]

And then I replied:
"Don't include Field4 in your report's record source and group by Fields 1,
2, & 3."