B
Bill Craig
I have a query (involving multiple tables) that I want to execute and then
use to enter/change data via the datasheet which results from the query.
On most queries, I am able to do that. One this one, I can't. What is the
criteria for determining what queries will allow data entry and which queries
won't?
What do I have to do to this query to allow data entry?
SELECT [4GateMeetingTimes].Time, ActivityTbl.Activity_ActivityKey,
ActivityTbl.Activity_Deployment, ActivityTbl.Activity_Name,
ActivityTbl.Activity_Status, ActivityTbl.Activity_Type,
ActivityTbl.Activity_PlannedProductionDate,
ActivityTbl.Activity_PlannedEndDate, ActivityTbl.Activity_ActualEndDate,
ActivityTbl.Activity_BusinessCase, ActivityFinancesTbl.ActFin_Funding,
ActivityFinancesTbl.ActFin_IO_IT_OM, ActivityFinancesTbl.ActFin_IO_BU_OM,
ActivityFinancesTbl.ActFin_IO_BU_Capital,
ActivityFinancesTbl.ActFin_Budget_IT_OM,
ActivityFinancesTbl.ActFin_Budget_IT_Capital,
ActivityFinancesTbl.ActFin_Budget_BU_OM,
ActivityFinancesTbl.ActFin_Budget_BU_Capital, GateTbl.Gate_Gate,
PanelRemarksTbl.PanelRemarks_Area, PanelRemarksTbl.PanelRemarks_Status,
PanelRemarksTbl.PanelRemarks_ClearByGate,
PanelRemarksTbl.PanelRemarks_ClearByDate,
PanelRemarksTbl.PanelRemarks_Comments
FROM ((4GateMeetingTimes INNER JOIN ActivityTbl ON
[4GateMeetingTimes].Activity_Key = ActivityTbl.Activity_ActivityKey) LEFT
JOIN ActivityFinancesTbl ON [4GateMeetingTimes].Activity_Key =
ActivityFinancesTbl.ActFin_ActivityKey) LEFT JOIN (GateTbl LEFT JOIN
PanelRemarksTbl ON GateTbl.Gate_ActivityGateKey =
PanelRemarksTbl.PanelRemarks_ActivityGateKey) ON
ActivityTbl.Activity_ActivityKey = GateTbl.Gate_ActivityKey
WHERE (((PanelRemarksTbl.PanelRemarks_Area)="BPM") AND
((GateTbl.Gate_PresentDate)=[Present Date]));
use to enter/change data via the datasheet which results from the query.
On most queries, I am able to do that. One this one, I can't. What is the
criteria for determining what queries will allow data entry and which queries
won't?
What do I have to do to this query to allow data entry?
SELECT [4GateMeetingTimes].Time, ActivityTbl.Activity_ActivityKey,
ActivityTbl.Activity_Deployment, ActivityTbl.Activity_Name,
ActivityTbl.Activity_Status, ActivityTbl.Activity_Type,
ActivityTbl.Activity_PlannedProductionDate,
ActivityTbl.Activity_PlannedEndDate, ActivityTbl.Activity_ActualEndDate,
ActivityTbl.Activity_BusinessCase, ActivityFinancesTbl.ActFin_Funding,
ActivityFinancesTbl.ActFin_IO_IT_OM, ActivityFinancesTbl.ActFin_IO_BU_OM,
ActivityFinancesTbl.ActFin_IO_BU_Capital,
ActivityFinancesTbl.ActFin_Budget_IT_OM,
ActivityFinancesTbl.ActFin_Budget_IT_Capital,
ActivityFinancesTbl.ActFin_Budget_BU_OM,
ActivityFinancesTbl.ActFin_Budget_BU_Capital, GateTbl.Gate_Gate,
PanelRemarksTbl.PanelRemarks_Area, PanelRemarksTbl.PanelRemarks_Status,
PanelRemarksTbl.PanelRemarks_ClearByGate,
PanelRemarksTbl.PanelRemarks_ClearByDate,
PanelRemarksTbl.PanelRemarks_Comments
FROM ((4GateMeetingTimes INNER JOIN ActivityTbl ON
[4GateMeetingTimes].Activity_Key = ActivityTbl.Activity_ActivityKey) LEFT
JOIN ActivityFinancesTbl ON [4GateMeetingTimes].Activity_Key =
ActivityFinancesTbl.ActFin_ActivityKey) LEFT JOIN (GateTbl LEFT JOIN
PanelRemarksTbl ON GateTbl.Gate_ActivityGateKey =
PanelRemarksTbl.PanelRemarks_ActivityGateKey) ON
ActivityTbl.Activity_ActivityKey = GateTbl.Gate_ActivityKey
WHERE (((PanelRemarksTbl.PanelRemarks_Area)="BPM") AND
((GateTbl.Gate_PresentDate)=[Present Date]));