G
Golfinray
SELECT [District Special Table].District_Id, [District Special
Table].District_Name_Long, [WA Capital Projects Special].CP_Scope, [WA
Capital Projects Special].CP_Status_ID, [Building
Special].Building_Name_Long, [School Special Table].Long_Name, [Capital
Project Category Special].CP_Category_Description, [Capital Project Status
Special].CP_Status_Description
FROM ((([WA Capital Projects Special] INNER JOIN [Capital Project Category
Special] ON [WA Capital Projects Special].CP_Category_ID = [Capital Project
Category Special].CP_Category_ID) INNER JOIN [Capital Project Status Special]
ON [WA Capital Projects Special].CP_Status_ID = [Capital Project Status
Special].CP_Status_ID) INNER JOIN ([District Special Table] INNER JOIN
[Building Special] ON [District Special Table].District_Id = [Building
Special].Building_Id) ON [WA Capital Projects Special].District_ID =
[District Special Table].District_Id) INNER JOIN [School Special Table] ON
[WA Capital Projects Special].School_ID = [School Special Table].School_Id;
This is the sql of a query that I have. The problem is it is not editable,
in other words at the bottm there is not the arrow and asterisk that allows
you to add records. Therefore, my form from this query is not editable
either. I have done everything I know to do, tried every type of join,
rebuilt the tables and query a dozen times. The tables came from linked
tables on ODBC sql server but I even copy and pasted them and made them
local. All the tables are editable and if I add the tables to the query one
at a time, the query is editable. I'm at my wits end. Help! Thanks!!!!
Table].District_Name_Long, [WA Capital Projects Special].CP_Scope, [WA
Capital Projects Special].CP_Status_ID, [Building
Special].Building_Name_Long, [School Special Table].Long_Name, [Capital
Project Category Special].CP_Category_Description, [Capital Project Status
Special].CP_Status_Description
FROM ((([WA Capital Projects Special] INNER JOIN [Capital Project Category
Special] ON [WA Capital Projects Special].CP_Category_ID = [Capital Project
Category Special].CP_Category_ID) INNER JOIN [Capital Project Status Special]
ON [WA Capital Projects Special].CP_Status_ID = [Capital Project Status
Special].CP_Status_ID) INNER JOIN ([District Special Table] INNER JOIN
[Building Special] ON [District Special Table].District_Id = [Building
Special].Building_Id) ON [WA Capital Projects Special].District_ID =
[District Special Table].District_Id) INNER JOIN [School Special Table] ON
[WA Capital Projects Special].School_ID = [School Special Table].School_Id;
This is the sql of a query that I have. The problem is it is not editable,
in other words at the bottm there is not the arrow and asterisk that allows
you to add records. Therefore, my form from this query is not editable
either. I have done everything I know to do, tried every type of join,
rebuilt the tables and query a dozen times. The tables came from linked
tables on ODBC sql server but I even copy and pasted them and made them
local. All the tables are editable and if I add the tables to the query one
at a time, the query is editable. I'm at my wits end. Help! Thanks!!!!