I have created a query which has the following sql format:
SELECT tbl_Stage_1.Category, tbl_Stage_1.Condition, tbl_Stage_1.Production_Date, Sum(tbl_Stage_1.Weight_lbs) AS SumOfWeight_lbs
GROUP BY tbl_Stage_1.Category, tbl_Stage_1.Condition, tbl_Stage_1.Production_Date
HAVING (((tbl_Stage_1.Category)="Accessories") AND ((tbl_Stage_1.Condition)="Premium") AND ((tbl_Stage_1.Production_Date) Between [Start] And [End]))
ORDER BY tbl_Stage_1.Category DESC , tbl_Stage_1.Condition DESC;
When I run the query, i get an error 3071: This expression is typed incorrectly.......
Any suggestions on how I could fix this error?
I am also new to databases so I request any suggestions or responses be easily understood by a beginner to databases.