jehanim009
New member
- Local time
- Tomorrow, 05:59
- Joined
- Dec 2, 2015
- Messages
- 5
Hi all,
I'm trying to append a query into one of my tables, the query runs fine as a select query but produces an error when used as an append query.
I've pasted the SQL of the Query below:
INSERT INTO TblSPlan ( StyleID, [Section], PlanDate )
SELECT QryGenerateDates.StyleID, QryGenerateDates.Section, QryGenerateDates.DateSeries
FROM QryGenerateDates
WHERE (((Month([DateSeries]))=[PlanMonth]) AND ((Exists (SELECT * FROM TblSPlan WHERE TblSPlan.PlanDate = QryGenerateDates.DateSeries AND TblSPlan.StyleID = QryGenerateDates.StyleID AND TblSPlan.Section = QryGenerateDates.Section))=False));
I'm assuming the problem is with the date field but have no idea how to solve it.
Any help would be much appreciated.
I'm trying to append a query into one of my tables, the query runs fine as a select query but produces an error when used as an append query.
I've pasted the SQL of the Query below:
INSERT INTO TblSPlan ( StyleID, [Section], PlanDate )
SELECT QryGenerateDates.StyleID, QryGenerateDates.Section, QryGenerateDates.DateSeries
FROM QryGenerateDates
WHERE (((Month([DateSeries]))=[PlanMonth]) AND ((Exists (SELECT * FROM TblSPlan WHERE TblSPlan.PlanDate = QryGenerateDates.DateSeries AND TblSPlan.StyleID = QryGenerateDates.StyleID AND TblSPlan.Section = QryGenerateDates.Section))=False));
I'm assuming the problem is with the date field but have no idea how to solve it.
Any help would be much appreciated.