Delete Query Problem

teabags

Registered User.
Local time
Today, 00:42
Joined
Jun 29, 2006
Messages
21
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 + "));
 
String concatenation in Access uses & (ampersand) not +. Is Week Number text data or integer?
 
its an integer
 

Users who are viewing this thread

Back
Top Bottom