'.Execute "DROP PROC [qCustomers]"
'.Execute "CREATE PROC [qCustomers] AS (SELECT DISTINCTROW [Customers].CustomerID, [Customers] , CompanyName, Customers.ContactFirstName, Customers.ContactLastName, Customers.BillingAddress, Customers.CBillingAddress, Customers.City, Customers.StateOrProvince, Customers.PostalCode, Customers.[Country/Region] AS CountryRegion, Customers.ContactTitle, Customers.PhoneNumber, Customers.Email, Customers.CellPhoneNumber, Customers.FaxNumber, Customers.Month, Customers.Cycle, Customers.CCompanyName, Customers.CContactFirstName, Customers.CContactLastName, Customers.CContactTitle, Customers.CCountryRegion, Customers.CFaxNumber, Customers.CPhoneNumber, Customers.CCellPhoneNumber, Customers.CEmail, Customers.CPostalCode, Customers.CStateOrProvince, Customers.CCity, Customers.CopyToBilling, Customers.Notes FROM Customers;)"
'.Execute "CREATE PROC[qCustomers] AS (SELECT DISTINCTROW [Customers].CustomerID, Customers.CompanyName, Customers.ContactFirstName, Customers.ContactLastName, Customers.BillingAddress, Customers.CBillingAddress, Customers.City, Customers.StateOrProvince, Customers.PostalCode, Customers.[Country/Region] AS CountryRegion, Customers.ContactTitle, Customers.PhoneNumber, Customers.Email, Customers.CellPhoneNumber, Customers.FaxNumber, Customers.Month, Customers.Cycle, Customers.CCompanyName, Customers.CContactFirstName, Customers.CContactLastName, Customers.CContactTitle, Customers.CCountryRegion, Customers.CFaxNumber, Customers.CPhoneNumber, Customers.CCellPhoneNumber, Customers.CEmail AS Expr1, Customers.CPostalCode, Customers.CStateOrProvince, Customers.CCity, Customers.CopyToBilling, Customers.Notes FROM Customers;)"
'.Execute "CREATE PROC [qCustomers] AS (SELECT DISTINCTROW [Customers].CustomerID, [Customers].CompanyName, [Customers].ContactFirstName, [Customers].ContactLastName, [Customers].Month, [Customers].Cycle, [Customers].BillingAddress, [Customers].CBillingAddress, [Customers].City, [Customers].StateOrProvince, [Customers].PostalCode, [Customers].[Country/Region] AS CountryRegion, [Customers].ContactTitle, [Customers].PhoneNumber, [Customers].CellPhoneNumber, [Customers].FaxNumber, [Customers].CCompanyName, [Customers].CContactFirstName, [Customers].CContactLastName, [Customers].CContactTitle, [Customers].CCountryRegion, [Customers].CFaxNumber, [Customers].CPhoneNumber, [Customers].CCellPhoneNumber, [Customers].CPostalCode, [Customers].CStateOrProvince, [Customers].CCity, [Customers].CopyToBilling, [Customers].Notes FROM Customers = [Customers].CustomerID;)"
What I have tried:
Everything above...for two days...please help
I am trying to drop a procedure in an access database and then build it up again. I have the code below but nothing is working. I know I am close but not close enough. This is for a module in an old vb 6 program.