Can't enter data in query datasheet
in [Queries]
|
Prev: How do I prevent values from been multiplied by two or three?
Next: How to make a query records as criteria to the other query
From: Bill Craig on 22 Apr 2010 13:53 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]));
From: Jerry Whittle on 22 Apr 2010 14:08
http://support.microsoft.com/?kbid=328828 -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Bill Craig" wrote: > 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])); > |