Any Suggestion for Contact Histroy Report?

Databases
1

Hi,

I have a database output from web, which contains many customer data, the format is something like below

Customer ID | Name | Company | ApproachDate

1234 | John | ABC Company | Jun-2009
2345 | Mary | BCD Company | May-2009
1234 | John | ABC Company | Apr-2009
2345 | Mary | DFG Company | Apr-2009
3456 | Peter| GHF Company | Mar-2010
2345 | Mary | DFG Company | Apr-2010

What I hope to do is to generate a summary report so that I can see the picture of a customer approach history, could anyone suggest if it is possible to achieve by SQL?

e.g.

Customer ID | Name | FirstCompany | FirstApproachDate | SecondCompany | ApproachDate | DateDifference | ThirdCompany | ApproachDate | DateDifference |
1234 | John | ABC Company | Apr-2009 | ABC Company | Jun-2009 | 2 months | NA |NA |NA |
2345 | Mary | DFG Company | Apr-2009 | BCD Company | May-2009 | 1 months | DFG Company |Apr-2010 |11 months|
3456 | Peter | GHF Company | Mar-2010 | NA |NA |NA |NA |NA |NA

Thanks!

2

yes, in msaccess you can use a crosstab query

3

yes it is possible to achieve with SQL but it is clumsy and complex

this kind of formatting or presentation of data is best done in the application

4

Can I do so with Microsoft access?