Please help me with this sql:
SELECT z005aNORTHEAST_ 3days_Formula.R egion,
z005aNORTHEAST_ 3days_Formula.D iffofClaimsAssi gnment
FROM (SELECT [test].Region, ([test].[Date to Service Provider])-(
[test].[Date Received By TNT]) AS DiffofClaimsAss ignment
FROM
(SELECT [Claims Table 02_23_05].Region, [Claims Table 02_23_05].[Date
received by TNT], [Claims Table 02_23_05].[Date To Service Provider],
[Claims Table 02_23_05].[Date Acknowledged by DSP]
FROM [Claims Table 02_23_05]
WHERE ((([Claims Table 02_23_05].Region)="NORTH EAST"))) as test) AS
z005aNORTHEAST_ 3days_Formula
WHERE (((z005aNORTHEA ST_3days_Formul a.DiffofClaimsA ssignment)<=3 ));
Access XP and 2003 returned correct data and correct nbr of records.
After the query was saved and re-opened, it also provided correct data
and nbr of records. Yet, whenever I revisited the design view and
clicked on "Save", Access popped up an error msg: "Syntax Error in FROM
Clause". Currently, I have only 400 records from the source table and
the sql generates 4 rows of returned records. I do not know how to fix
it & could not understand why Access automatically changed the sql
after I reopend it (plz see below), but still show error msg. Thank you
in advance. James in Plano
SELECT z005aNORTHEAST_ 3days_Formula.R egion,
z005aNORTHEAST_ 3days_Formula.D iffofClaimsAssi gnment
FROM [SELECT [test].Region, ([test].[Date to Service Provider])-(
[test].[Date Received By TNT]) AS DiffofClaimsAss ignment
FROM
(SELECT [Claims Table 02_23_05].Region, [Claims Table 02_23_05].[Date
received by TNT], [Claims Table 02_23_05].[Date To Service Provider],
[Claims Table 02_23_05].[Date Acknowledged by DSP]
FROM [Claims Table 02_23_05]
WHERE ((([Claims Table 02_23_05].Region)="NORTH EAST"))) as test]. AS
z005aNORTHEAST_ 3days_Formula
WHERE (((z005aNORTHEA ST_3days_Formul a.DiffofClaimsA ssignment)<=3 ));
SELECT z005aNORTHEAST_ 3days_Formula.R egion,
z005aNORTHEAST_ 3days_Formula.D iffofClaimsAssi gnment
FROM (SELECT [test].Region, ([test].[Date to Service Provider])-(
[test].[Date Received By TNT]) AS DiffofClaimsAss ignment
FROM
(SELECT [Claims Table 02_23_05].Region, [Claims Table 02_23_05].[Date
received by TNT], [Claims Table 02_23_05].[Date To Service Provider],
[Claims Table 02_23_05].[Date Acknowledged by DSP]
FROM [Claims Table 02_23_05]
WHERE ((([Claims Table 02_23_05].Region)="NORTH EAST"))) as test) AS
z005aNORTHEAST_ 3days_Formula
WHERE (((z005aNORTHEA ST_3days_Formul a.DiffofClaimsA ssignment)<=3 ));
Access XP and 2003 returned correct data and correct nbr of records.
After the query was saved and re-opened, it also provided correct data
and nbr of records. Yet, whenever I revisited the design view and
clicked on "Save", Access popped up an error msg: "Syntax Error in FROM
Clause". Currently, I have only 400 records from the source table and
the sql generates 4 rows of returned records. I do not know how to fix
it & could not understand why Access automatically changed the sql
after I reopend it (plz see below), but still show error msg. Thank you
in advance. James in Plano
SELECT z005aNORTHEAST_ 3days_Formula.R egion,
z005aNORTHEAST_ 3days_Formula.D iffofClaimsAssi gnment
FROM [SELECT [test].Region, ([test].[Date to Service Provider])-(
[test].[Date Received By TNT]) AS DiffofClaimsAss ignment
FROM
(SELECT [Claims Table 02_23_05].Region, [Claims Table 02_23_05].[Date
received by TNT], [Claims Table 02_23_05].[Date To Service Provider],
[Claims Table 02_23_05].[Date Acknowledged by DSP]
FROM [Claims Table 02_23_05]
WHERE ((([Claims Table 02_23_05].Region)="NORTH EAST"))) as test]. AS
z005aNORTHEAST_ 3days_Formula
WHERE (((z005aNORTHEA ST_3days_Formul a.DiffofClaimsA ssignment)<=3 ));
Comment