Syntax error in FROM Clause

[dancedj05]

Can someone please help me with this script?

PARAMETERS [Enter start date] DateTime, [Enter end date] DateTime;
SELECT "Jxx" AS [Batch ID], Q.POST_DT AS [Date], "Jxx" AS [Source Document], Trim(Left([Q].[DES],40)) AS Reference, Q.Account, CCur(IIf([Q].[Amt]>=0,Round([Q].[Amt],2),0)) AS [Debit Amount], CCur(IIf([Q].[Amt]<0,Round(abs([Q].[Amt]),2),0)) AS [Credit Amount], Q.REF AS [Distribution Reference], Q.CO_CD, CCur(Round([Q].[Amt],2)) AS AMT, IIf([q].[CO_CD]="AZ","MFAL","RTL") AS GP_Co, Trim(Q.CO_UNIT) AS CO_UNIT, Trim(Left(Q.CMNT,70)) AS CMNT
FROM SELECT
A.Co_Cd as CO_CD
, ( '257460' & A.Mkt_cd & A.Store_Cd ) AS [Account]
, 'TWF' AS EMP_CD_OP
, [Enter end date] AS POST_DT
, ( 'Mkt ' & A.Mkt_Cd & ' non-rtn ICA-' & trim( A.ITT_Sub_Cd ) & ' rcls ' & Format( [Enter end date],'yyyy-mm-dd') ) AS DES
, 'Non-rtn rcls' AS REF
, sum( -A.Cost_extended ) AS AMT
, trim(A.Store_cd) AS CO_UNIT
, ( A.Mkt_Store_Cd & ' non-rtn ICA-' & trim( A.ITT_Sub_Cd ) & ' reclass ' & Format( [Enter end date],'yyyy-mm-dd') ) AS CMNT
FROM [qITT_ICA_Not_from_Returns] AS A
where
A.ITT_Sub_Cd in ( [Enter Sub Cd] )
group by
A.Co_Cd
, A.Mkt_Store_Cd
, A.Mkt_Cd
, A.Store_cd
, A.ITT_Sub_Cd

UNION SELECT
A.Co_Cd as CO_CD
, ( switch( A.ITT_Sub_cd = 'CMF' , '2577', A.ITT_Sub_cd='WAR', '2570', TRUE, A.ITT_Sub_Cd & '!' ) & '60' & A.Mkt_cd & A.Store_Cd ) AS [Account]
, 'TWF' AS EMP_CD_OP
, [Enter end date] AS POST_DT
, ( 'Mkt ' & A.Mkt_Cd & ' non-rtn ICA-' & trim( A.ITT_Sub_Cd ) & ' rcls ' & Format( [Enter end date],'yyyy-mm-dd') ) AS DES
, 'Non-rtn rcls' AS REF
, sum( A.Cost_extended ) AS AMT
, trim(A.Store_cd) AS CO_UNIT
, ( A.Mkt_Store_Cd & ' non-rtn ICA-' & trim( A.ITT_Sub_Cd ) & ' reclass ' & Format( [Enter end date],'yyyy-mm-dd') ) AS CMNT
FROM [qITT_ICA_Not_from_Returns] AS A
where
A.ITT_Sub_Cd in ( [Enter Sub Cd] )
group by
A.Co_Cd
, A.Mkt_Store_Cd
, A.Mkt_Cd
, A.Store_cd
, A.ITT_Sub_Cd

AS Q
WHERE ((([Q].[AMT])<>0));

[iburyak]

Half of statements here are not SQL rather VB statements like :

1.

IIf([q].[CO_CD]="AZ","MFAL","RTL") AS GP_Co, Trim(Q.CO_UNIT) AS CO_UNIT, Trim(Left(Q.CMNT,70)) AS CMNT

2.

Format( [Enter end date],'yyyy-mm-dd')

3. You have Select right after From what is it?
If you want to use internal table - put it in parenthesis and give it an alias like:

Select .....
FROM ( Select ...... From ... Where ...) tmp

Are you sure you are in a right forum?
Is this Access?

[dancedj05]

Half of statements here are not SQL rather VB statements like :

1.

IIf([q].[CO_CD]="AZ","MFAL","RTL") AS GP_Co, Trim(Q.CO_UNIT) AS CO_UNIT, Trim(Left(Q.CMNT,70)) AS CMNT

2.

Format( [Enter end date],'yyyy-mm-dd')

3. You have Select right after From what is it?
If you want to use internal table - put it in parenthesis and give it an alias like:

Select .....
FROM ( Select ...... From ... Where ...) tmp

Are you sure you are in a right forum?
Is this Access?

This is Access? I am in the wrong Forum. Apologies

[iburyak]

Anyway in Access you should create a separate query for internal result set and then use this query in from instead of Select statement.


You have

From Select ......

it should be
From Query_name