Query Prompting for Input

  • Thread starter Thread starter Hank
  • Start date Start date
H

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!
 
Hank said:
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.
Click to expand...

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.
 
Back
Top