Hi
I am tring to delete all week ids (weekid) that are greater than weekid from my table 3weekthisweek.
Week id is unique number that identifies week.
But I am getting a type mismatch error what am i doing wrong.
Here is my query
DELETE [3WeekThisWeek].[Week Number] FROM 3WeekThisWeek WHERE ((([3WeekThisWeek].[Week Number])>" + weekid + "));
I am tring to delete all week ids (weekid) that are greater than weekid from my table 3weekthisweek.
Week id is unique number that identifies week.
But I am getting a type mismatch error what am i doing wrong.
Here is my query
DELETE [3WeekThisWeek].[Week Number] FROM 3WeekThisWeek WHERE ((([3WeekThisWeek].[Week Number])>" + weekid + "));