Delete From query problem (Access 2007)

[David Eagar]

I want to create a delete query and all is fine until I get to the step of selecting FROM in the query. Every time I select it, it jumps straight back to WHERE.

Even if I code it in sql, still get message "Please specify the table"

Any help appreciated as this is driving me nuts

 

[WayneRyan]

David,

Need more info, are you in the Query Designer?

What's the name of the table?

Can you post a sample?

Wayne

 

[David Eagar]

Yep, in design mode and problem enclosed. When I try abd change from Where to From, it don't(?)

 

[ST4RCUTTER]

I am having this same problem and I think this problem is caused by how my table is related. In my case I have a table (tbl_tasks) that is on the one side of a one-to-many relation ship with a data table (tbl_dates). Basically any given task can have multiple dates. Now when I try to create a delete query the Delete row won't let me select the "From" value. Any idea why this is happening?

It should also be noted that the table for dates stores the related Task ID, Date, and a DateTypeID which is related to a reference table using one-to-many relationship. In this case the reference table is on the "one" side.