I have a query in SQL which works fine ie. lists the query results (just the way I want it) without any pop up dialog box when I run it without saving it.
After I save and close it and run the query, it brings up a dialog box that prompts you for the parameter value (criteria).
Why is this the case? What is wrong with the query? Can I disable the pop dialog box?
The query for example is as follows:
SELECT [table1].[Item],
[table1].[ItemDesc],
[table1].[Form],
[table1].[Dia],
[table1].[Length],
[table2].[Qty]
FROM [table1] INNER JOIN [table2] ON [table1].[Form]=[table2].[Form]
WHERE [table1].[Item] NOT IN
(SELECT [table1].[Item]
FROM [table1]
WHERE
((([table1].[Form]) Like "*BQ*") AND (([table1].[Length])<2)));
I hope this helps in understanding the probelm. Any suggestion would be greatly appreciated but in solving the problem or on improving the query. Thanks in advance.
After I save and close it and run the query, it brings up a dialog box that prompts you for the parameter value (criteria).
Why is this the case? What is wrong with the query? Can I disable the pop dialog box?
The query for example is as follows:
SELECT [table1].[Item],
[table1].[ItemDesc],
[table1].[Form],
[table1].[Dia],
[table1].[Length],
[table2].[Qty]
FROM [table1] INNER JOIN [table2] ON [table1].[Form]=[table2].[Form]
WHERE [table1].[Item] NOT IN
(SELECT [table1].[Item]
FROM [table1]
WHERE
((([table1].[Form]) Like "*BQ*") AND (([table1].[Length])<2)));
I hope this helps in understanding the probelm. Any suggestion would be greatly appreciated but in solving the problem or on improving the query. Thanks in advance.
