Enter Parameter Value

[Lamb2087]

I created a query where when I click on it to run a dialog box pops upa dn says "Enter Parameter Value"
Can you some one tell me how to get this dialog box not to show up everytime I click on the query. I have created the same query in another DB and it works with out the annoying message showing up.

 

[RV]

Post your SQL statement ('query code")

RV

 

[Lamb2087]

Query SQL

SELECT [CADET_NO], [dbo_RifleInventory].[PEOPLE_ID], [SERIAL], [SLOT], [TROOP], [DRILL_TEAM], [JR_OR_SR], [DORM_ROOM], [DORM_PLAN], [PREVIOUS_ID], [FIRST_NAME], [MIDDLE_NAME], [LAST_NAME], [dbo_PEOPLE1].[PEOPLE_ID]
FROM RifleInventoryQuery;