arrays + report

[CompGirl]

I would like to do as follow.... first i want to create an array and print it out on a report... the thing is that i want the same values to be printed out on the same place with a , between... like this

salesman programmer author
Anna 1,2 3
Bella 4 5
Brad

the numbers are IDs... and 1,2 are two Annas that are both salesman... and so on.. i think u get the picture... now i have no idea on how to do this... any help will be good.. thx

 

[DonQuichote]

First, you'll have to decide if you want to use an array or if you can get these results from a table using a query.

If you can use a query, you can use a subreport or grouping. Look in the helpfile how to do this.

But I assume you really want to do it with an array. I also assume the size of this array is variable. You can use the

ReDim Preserve statement

statement, but be warned that you can only change one dimension.

Now here's a trick: you can use a multiline textbox or a listbox to display the data. It may require a little testing to see which event you have to generate the data in, but it should work...

Best regards

 

[CompGirl]

thanks.. i tried the crosstab report to see if its any easier... it seems to work well but it hasnt got everything that i wanted... for example after choosing the IDs that i would like to be shown you have to choose between count, var sum etc... can i get pass this in another way... since i want every ID number to be shown with a comma between?