BlackKnight
Programmer
Hi folks,
I am converting Access queries to SQL 7.0 statements.
In an Access select query I have a reference to a control on a form. How do I convert the query to a SQL 7.0 statement? Here is the query: Thanx in advance.
SELECT DISTINCTROW tblCustomerContactDepartment.strDepartmentName, tblCustomer.strCompanyName, tblCustomerContactDepartment.strContactID
FROM tblCustomer INNER JOIN tblCustomerContactDepartment ON tblCustomer.strCustomerID = tblCustomerContactDepartment.strContactID IN 'customer.mdb'
WHERE (((tblCustomerContactDepartment.strContactID)=[Forms]![frmCustomerContact].[zstxtCustomerID]))
ORDER BY tblCustomerContactDepartment.strDepartmentName
WITH OWNERACCESS OPTION;
Have a good one!
Keith
I am converting Access queries to SQL 7.0 statements.
In an Access select query I have a reference to a control on a form. How do I convert the query to a SQL 7.0 statement? Here is the query: Thanx in advance.
SELECT DISTINCTROW tblCustomerContactDepartment.strDepartmentName, tblCustomer.strCompanyName, tblCustomerContactDepartment.strContactID
FROM tblCustomer INNER JOIN tblCustomerContactDepartment ON tblCustomer.strCustomerID = tblCustomerContactDepartment.strContactID IN 'customer.mdb'
WHERE (((tblCustomerContactDepartment.strContactID)=[Forms]![frmCustomerContact].[zstxtCustomerID]))
ORDER BY tblCustomerContactDepartment.strDepartmentName
WITH OWNERACCESS OPTION;
Have a good one!
Keith