Querydef parameters issue

[MMcCarthy]

Thanks for bailing me out on this one, Mary. I was far off somewhere on some Parameter Tangent!

No problem, you've bailed me out enough times.

[phytorion]

Alright thank you for all your help. I think i know what i need to change now.


Eric

[MMcCarthy]

Alright thank you for all your help. I think i know what i need to change now.


Eric

No problem Eric.

Let us know if you need further help.

[phytorion]

Alright one more question...The DELETE SRCE_TBL_STRUCT URE.* seems to of solve my original problem,(atleas t its stepping further through before it errors out),but now its giving me an error saying i have to few parameters(expe cts 6). The problem is that the three parameters i listed are what identifies the rows i want to delete. Is there a way to pass a wildcard or ignore the rest of the parameters it's expecting?


[code=vb]PARAMETERS [Target Table] Text ( 255 ), [App Vsn] Text ( 255 ), [Cust ID] Text ( 255 );
DELETE SRCE_TBL_STRUCT URE.*
FROM SRCE_TBL_STRUCT URE INNER JOIN qryForfrmBuildD escrTabOuterTab le ON SRCE_TBL_STRUCT URE.TABLE_NAME= qryForfrmBuildD escrTabOuterTab le.TRGT_TBLNAME ;
[/code]

[phytorion]

Nevermind I solved the problem. Thanks for all the help

Eric