Hi

I have a table with products.
To this table is another table with 1 record / month.
To each month there is MAX 1 record. Sometimes none.

i.e
MyProduct 2003 1 SomeValue
MyProduct 2003 2 SomeValue
MyProduct 2003 3 SomeValue
MyProduct 2003 5 SomeValue

etc.

I have a customer, that would like to see the values 12 month back in
time
on a single line.
Someting like this:

My Product 01/2003 02/2003 03/2003 04/2003 etc
value value value value


is something like pivot in Access.

Can I do that ?

Michael