Grouping and dates

[loonytoons]

Hi guys,



I have a theoretical question.

I have a table that contains rows that have postcode, house number and the date of a transaction.
Therefore, the table contains lots of rows that refer to the same postcode/house number, but the date is different.

Records need to be grouped by postcode/house number.
I then need to be able to list the dates that refer to that postcode/house number

Some addresses will have 1 date applied, some will have 10.

I want to be able to show the grouped postcode/house number with all the dates that apply to that grouping.

Is that possible?

Thanks,
Sandra

[pbaldy]

Typically done with a function like:

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

[lfpm062010]

As long as the data for postcode/house number are consistent.

You can sort by postcode/house number. Then it will list all the dates in the postcode/house number.

[loonytoons]

pbaldy, thanks for the suggestion - works a treat

[pbaldy]

Happy to help and welcome to the site!