Recent content by onwagena

I have a table with 2 columns: Column1 Column2 ----- ------------ Aa TextA Bb TextB Cc TextC And I must transform this to an new table like this: Aa Bb Cc ----- ----- ----- TextA TextB TextC The values of column1 must be the columnheader in the new table The...

Thanks, This is wat I was looking for.

Oracle 9i

I have a table looking like this: Verr Date 1 1-9-2006 1 2-9-2006 1 3-9-2006 2 5-9-2006 2 6-9-2006 3 2-9-2006 4 1-9-2006 4 5-9-2006 4 7-9-2006 4 9-9-2006 I would like to see the latest 2 dates of every Verr. The result must look like Verr Date 1 2-9-2006 1...

Thanks all of you and special Dagon. The correct SQL statement is : select t.id, m.month_no, (least(t.enddate, m.enddate) - greatest(m.begindate, t.begindate)+1)/(t.enddate - t.begindate +1) * amount from table t, month_year m where m.begindate between t.begindate and t.enddate or m.enddate...

I have a report in Access and I want this report sent by email to several people. How can I compose an email with as body the report that I want to sent. I don't want to have the report as an attachment.

The split is %aage over the number of months.

I have a table with the following records: ID Begindate Enddate Amount 1 1-1-2005 15-9-2005 17 2 16-9-2005 31-12-2005 7 I need a table like this: ID Month Amount 1 1 2 1 2 2 ... 1 9 1 2 9 1 2...