grouping data

[JEPEDEWE]

Hi
I have a table looking like the jpg file I send
What I would like is a report grouped on records with the same code, but, (and this is the tricky part), with a field where "Referentie" is the result of putting all "Referentie" one after another, and where "BEDRAG_a" is summed
Something like this:

24061069 210,8 1653698-1653697
31080004 189,72 1653780-1653781-164382
18070064 126,48 1653709-1653710

Anybody has an idea?? :think:

Thanks a lot

[mohanvijay]

you can't group the number field in MS-Access like you said.but you can use another way to do that.

1. Get the "'Code" field and summed "BEDRAG_a" field by using "GROUP BY" clause in query (Paste in Sheet1)
2. Get the "'Code" field and "Referentie" field by without using "GROUP BY" clause (Paste in Sheet2)

3. Create Custom function to Group the "Referentie" field

I use the above way to get the result