Query SQL

[haj1503]

Hi friend,
Hi get meassage something like this "Syntax Error is FROM clause" i do like this:
SELECT a.MinDate, b.MaxDate, a.MinDE1-Gen_A, b.maxDE1-Gen_A, a.MinDE2-Gen_A, b.maxDE2-Gen_A, a.MinDE3-Gen_A, b.maxDE3-Gen_A, a.MinDE4-Gen_A, b.maxDE4-Gen_A
FROM [SELECT Prod_DE.Date AS MinDate, Prod_DE.[DE1-Gen_A+] AS [MinDE1-Gen_A], Prod_DE.[DE2-Gen_A+] AS [MinDE2-Gen_A], Prod_DE.[DE3-Gen_A+] AS [MinDE3-Gen_A], Prod_DE.[DE4-Gen_A+] AS [MinDE4-Gen_A],
FROM Prod_DE
WHERE Date=DMin("[Date]","Prod_DE&quot]. AS a, [SELECT Prod_DE.Date AS MaxDate, Prod_DE.[DE1-Gen_A+] AS [MaxDE1-Gen_A], Prod_DE.[DE2-Gen_A+] AS [MaxDE2-Gen_A], Prod_DE.[DE3-Gen_A+] AS [MaxDE3-Gen_A], Prod_DE.[DE4-Gen_A+] AS [MaxDE4-Gen_A]
FROM Prod_DE
WHERE Prod_DE.Date=DMax("[Date]","Prod_DE&quot]. AS b;

Can somebody tell me what actually the problem.
You Advance assistance must be appreciated.

haj1503

 

[tlbroadbent]

I've provided the answer in thread181-131273. You must remove the extra comma in the query.
[tt]
AS [MinDE4-Gen_A],
FROM Prod_DE[/tt] Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous