Query Prompting for Input

[Hank]

I've got the following query and it's prompting me to input Account
Status. I thought I had it coded to look for AcctStatus is 'A'. I did
this in design view.

SELECT DISTINCT qryUsedDIDs.DID, qryUsedDIDs.ClientName,
qryUsedDIDs.ClientType, [tblMasterClients].[AlphaPrefix] & "-" &
[tblMasterClients].[SiteID] & " -" & [ClientType] & "-" &
Mid([DID],InStr(1,[DID],"-")+1) AS [Client Number],
tblMasterClients.AcctStatus

FROM tblMasterClients INNER JOIN qryUsedDIDs ON
tblMasterClients.ClientName = qryUsedDIDs.ClientName

WHERE (((qryUsedDIDs.DID)<>"000-7777" And (qryUsedDIDs.DID)<>"000-8888"
And (qryUsedDIDs.DID)<>"000-6666" And (qryUsedDIDs.DID)<>"000-9999") AND
((tblMasterClients.AcctStatus)='A'));


Thanks!

 

[Guest]

I've got the following query and it's prompting me to input Account
Status. I thought I had it coded to look for AcctStatus is 'A'. I did
this in design view.

Access asks for inputs any time there's an unbound input. What you should do
is...

1) open the query in design mode
2) right-click in the resulting window, choose properties
3) click on the tab that shows the inputs (middle one I think) and type in
"A" as the default for that input.

I don't see any inputs in the sample code you sent, so I'm not sure if this
is the problem or not. If this isn't, send the entire DDL (ALTER
PROCEDURE...) text, the select statement alone isn't enough.