Simple Delete Query- Can't Delete records

[spudd]

I have a simple delete query.

Made up of 2 queries.

Query 1 [Upper and Lower dates] finds the max and min out of set of records [Lower1]

Query 2 contains the data.[Demand]

What I want to do is delete the data that is less than [Demand].[WkYr]

DELETE DISTINCTROW demand.*, demand.WkYr
FROM demand, [Upper and Lower Dates]
WHERE (((demand.WkYr)<[Lower1]));

When I look at the datasheet the data is correct that I want to delete, but the query falls over when I run it. "Could Not Delete from Specified Tables"

I have set the Unique records to YES.

Cheers

Andy

 

[CharlesChuckieCharles]

I have a simple delete query.

Made up of 2 queries.

Query 1 [Upper and Lower dates] finds the max and min out of set of records [Lower1]

Query 2 contains the data.[Demand]

What I want to do is delete the data that is less than [Demand].[WkYr]

DELETE DISTINCTROW demand.*, demand.WkYr
FROM demand, [Upper and Lower Dates]
WHERE (((demand.WkYr)<[Lower1]));

When I look at the datasheet the data is correct that I want to delete, but the query falls over when I run it. "Could Not Delete from Specified Tables"

I have set the Unique records to YES.

Cheers

Andy

try removing

DISTINCTROW demand.*,

 

[spudd]

Tried that as a solution, but just keeps asking to Specify the table to delete from.

DELETE demand.WkYr
FROM demand, [Upper and Lower Dates]
WHERE (((demand.WkYr)<[Lower1]));

Above is the new sql.

Cheers

Andy

 

[CharlesChuckieCharles]

Open your query in design view
in 2007 where on the ribbon bar you have the greek letter for adding totals (the show/Hide section on the right hand side)

there is a property sheet open this and change the Unique record entry from no to yes