conversion of SQL in to VB. (access 2k)

[Guest]

I have the following SQL query which i am trying to modify after an update of
a combo, i am using DAO (as it got an example in a book i have) and i am
having trouble converting it into VB.

the example is for creating a crosstab query so i have made some
assumptions......

could someone please help me.

SELECT Master_KPI_qry.CSR_Number, Master_KPI_qry.Option_Name,
Master_KPI_qry.Nom_Date, Master_KPI_qry.[Date Of Nom Visit],
Master_KPI_qry.Pln_dwg_Rec, DateDiff("d",[Date Of Nom Visit],Now())-7 AS
[Days Overdue], Master_KPI_qry.Contractor_Name
FROM Master_KPI_qry
WHERE (((Master_KPI_qry.Nom_Date) Is Not Null) AND
((Master_KPI_qry.Pln_dwg_Rec) Is Null) AND ((DateDiff("d",[Date Of Nom
Visit],Now())-7)>=0) AND
((Master_KPI_qry.Contractor_Name)=[Forms]![company_filter_tbl]![Combo2]))
ORDER BY Master_KPI_qry.Contractor_Name, Master_KPI_qry.CSR_Number;

 

[Perry]

Crosstab query?
really ?

Below statement doesn't smell like a crosstab query, to me.
They start with a "TRANSFORM"
Last line of of the SQL string should start with PIVOT BY

Could you re-read yr books, and forward the real SQL?
Krgrds,
Perry