OK after some thinking and thanks to your input, I believe I was able
to combine the two queries into one.

DoCmd.RunSQL " INSERT INTO tblLC ( strDescription, strAC,
sngLCPrice ) SELECT [11030204].strDescription, [11030204].strAC,
[11030204].[000111022001] " _
& " FROM [11030204] WHERE ((([11030204].[000111022001]) Is Not Null
And ([11030204].[000111022001])<=nz([11030204].[001011022402]) And
([11030204].[000111022001])<=nz([11030204].[000211022301]))) ;"

Since I know the table name and the number and name of the fields I
could come up with the appropriate SQL string statement. We'll see how
it behaves if we have more fields.

Many thanks,
John

JohnP wrote:

Hope you get it to work. I was simply providing a method example to
demonstrate to you on how to define and assign a SQL statement to
Query5. IOW, create the Sql statement on the fly and update the SQL
statement in Query5. No brain surgery required.

Many thanks Salad for your assistance.
John