query works in Access, but not through script
Posted on 2005-04-17
INSERT INTO custPoints (cust_num, month, year, points)
SELECT customers.cust_num, 4, 2005, SUM(amount) * (SELECT pointValue FROM pointValue)
FROM sales INNER JOIN customers ON sales.cust_num=customers.cust_num WHERE saleDate >= #5/1/2004# AND saleDate <= #5/31/2004# GROUP BY customers.cust_num
works when I type it directly into my access DB, but not when I run it through my script. How can this be?!?!?! It gives me the generic error of "Syntax error in INSERT INTO statement"
Yeah yeah, I know I know, I should be using a real db for this....I know that now... :(