When I run this query access asks for only one parameter

D

dennist685

Here is the query

SELECT KSGroups.KSGroup, KSGroups.ID
FROM KSGroups INNER JOIN (KeywordSets INNER JOIN KSGroupKSAssignments ON
KeywordSets.ID = KSGroupKSAssignments.KeywordSetID) ON KSGroups.ID =
KSGroupKSAssignments.KSGroupID
WHERE (((KSGroups.ID)=[?]) AND ((KeywordSets.ID)=[?]))
ORDER BY KSGroups.KSGroup

It seems to me access should be asking first for the ksgroups.id and then
keywordsets.id.

If not, how should the query look so that it asks for both parameters.

thanks,

dennist685
 
R

Rick B

It would if you used a unique prompt. How will your users know what you are
asking? A better way would be...

....WHERE (((KSGroups.ID)=[Enter KS Group ID]) AND ((KeywordSets.ID)=[Enter
Keyword Set ID]))...
 
Top