Hi,
spacemarc wrote:
> Hi
> my table have three fields that, if selected, are shown like:
>
> area1, value_one, thing_one
> area1, value_two, thing_32
> area1, value_three, thing_ dd
> area2, value_ten, thing_6w
> area2, value_ff, thing_l
> ....
> ....
>
> can I obtain a recordset like this?
>
> area1, value_one, thing_one
> //, value_two, thing_32
> //, value_three, thing_ dd
> area2, value_ten, thing_6w
> //, value_ff, thing_l
>
> So, do not repeat more times the value of the first column (area1,
> area2...)
Giuseppe Maxia wrote a great article on this some time ago. The technique is called
cross-tabulation or pivot tables. Here is a link:
http://www.onlamp.com/pub/a/onlamp/2003/12/04/crosstabs.html
Baron
