Search results

FYI - I finally got it; I changed from using a join to using a where clause: DELETE tblB.* FROM tblB where AGPD_PFX in (Select distinct AGPD_PFX from [tblA]) I was doing a different type of query altogether and was applying a similar subquery and just thought I'd try it out. Deletion...

I didn't have primary keys set on one of the tables; I made that adjustment and reran the query - still the same error appears.

Hi - I made the changes you suggested; I added the inner join, so removed the where clause (as my join was my criteria for deletion). I am still receiving the error 'could not delete from specified tables'. I tried this in both design and SQL view; my exact syntax is copied below. Can you...

Delete query still doesn't work for me... Hi - I follow your instructions for building my delete query; when I run it, it asks for a parameter from the field on tbl B where I specified the delete criteria. My query looks like this: DELETE [Cherise].* FROM [Cherise] WHERE [RM_TYPE].SESE_ID =...

Thanks for the advice - I went the query route - and used it to create a report. I appreciate the help!

Thanks for the information; however, I can't seem to get the statement to work - by setting as criteria for the field in the form, in a query, as a macro. I'm obviously missing something - could you please clarify where I'm supposed to apply it? Thanks much.

Hi - I am trying to develop a form that contains a field that shows a date calculated based on a text field and other date. I figured out how to build a query to get this for one sort of value, but what I really, really need is to do this for multiple situations: If [Priority]="High", then...