Recent content by K-CJ

My grouping criteria is per unique street name. I want to show the index blocks in which each street falls. E.g. 1st Ave falls in index blocks F9, F8, G9 and Bennet St falls in index blocks D7, D8 etc. Do you understand what I mean? Thanks :)

Thanks Uncle Gizmo, but the code in the module in that zip file example is already what I've got so far. I need to have it listed per unique entry (grouped) and not everthing in the whole table in one row.

Hi, I am creating a street map index and would like to create a function that lists all the index grid blocks per street separated by a comma. The data that I have looks like this: StreetName___IndexBlock 1st Ave _______F9 1st Ave _______G8 1st Ave _______G9 Bennet St _____D7 Bennet St...

In my case the problem was that I added the wrong field in my query that the paramater is based on. The parameter ([Forms]![Form1]![idBplanApplication]) I did not add in my query but as a filter for my recordset. By adding the correct fieldname (BPlanApplication.idBplanApplication from my main...

I had exactly the same problem as Ally. After spending many hours trying most of the suggestions above which created the same results as for Ally, I finally found the solution to my particular problem. So, if anyone else comes across the same problem, I'd like to share the other thing that might...