คือว่าผมไม่ต้องการให้ข้อมูลที่มีชื่อเดียวกันออกมาครับ อยากให้ออกมาแค่รายการเดียว
/////////////////////ตัวอย่างโค๊ดใน sql ครับ
SELECT accounts.name, accounts.billing_address_street, accounts.billing_address_city, accounts.billing_address_state, accounts.billing_address_postalcode, accounts.billing_address_country, project_cstm.plateno_c, project_cstm.brand_c, project.name AS ContractNo, wrt_contractpackage.description, showonlabel([Forms]![CC-Sales Reports Dialog]![FromDate],[estimated_start_date],[estimated_end_date]) AS ISCall, project.estimated_start_date, project.estimated_end_date, accounts.phone_fax, accounts.phone_office, accounts.phone_alternate, project.name, project_cstm.model_c, project_cstm.color_c, project_cstm.group_c, project_cstm.cartype_c
FROM project_cstm INNER JOIN (accounts INNER JOIN ((wrt_contrackage_project INNER JOIN (projects_accounts INNER JOIN project ON projects_accounts.project_id = project.id) ON wrt_contrackage_project.project_idb = project.id) INNER JOIN wrt_contractpackage ON wrt_contrackage_project.wrt_contractpackage_ida = wrt_contractpackage.id) ON accounts.id = projects_accounts.account_id) ON project_cstm.id_c = project.id
WHERE (((showonlabel([Forms]![CC-Sales Reports Dialog]![FromDate],[estimated_start_date],[estimated_end_date]))=Yes) AND ((project.estimated_end_date)>=CVDate("01-DEC-1990")) AND ((Format([estimated_end_date],"yymm"))>=Format(Date(),"yymm")));