Syntax error in SQL query

[Bren Pierce]

I'm getting a Syntax error (missing operator) in query expression,
‘where_Fact_Orders.Transport_Days >3’.

 

[Ken Snell \(MVP\)]

Without seeing the entire SQL statement, I can only guess that this WHERE
clause snippet should be this:

where Fact_Orders.Transport_Days >3

 

[Bren Pierce]

Thanks Ken:
Here's the SQL statement

SELECT DISTINCTROW Dim_Shipping_Company.Shipping_Company_Name,
Fact_Orders.Order_Num, Fact_Orders.Order_Shipped_Date,
Fact_Orders.Delivery_Date, Fact_Orders.Transport_Days, 1 AS Order_Count
FROM Dim_Shipping_Company INNER JOIN Fact_Orders ON
Dim_Shipping_Company.Shipping_Company_ID = Fact_Orders.Shipping_Company_ID
GROUP BY Dim_Shipping_Company.Shipping_Company_Name, Fact_Orders.Order_Num,
Fact_Orders.Order_Shipped_Date, Fact_Orders.Delivery_Date,
Fact_Orders.Transport_Days, 1;

 

[Ken Snell \(MVP\)]

Your SQL statement does not contain a WHERE clause? Please explain how the
'where_Fact_Orders.Transport_Days >3' text string corresponds to this SQL
statement, and the context in which you're using this text string.
--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/