Query to print report

[ksgirl]

I've been searching and cannot find an answer to my question! So I guess I'll go ahead and post it. I have a query set up to search for all the 'tags' associated to it's primary key the 'Clearance ID', and these results are displayed on a form where the user can scroll through the different tags. My problem is that I want to query within these results where one of the fields ('Tag status') equals a certain message: "Added", so that the report only prints the tags with that value. There are three options for the tag status either added, existing, or removed, and the way I have the query set up now( in the report), it brings up ALL the tags. I guess my main question is how do you query within a query? Does anyone have any suggestions??
Thanks!

 

[RV]

If I understand your post, your report is based on a query.
Why don't you add a condition to your query (or am I missing your point?):

SELECT...
FROM....
WHERE....
AND TagStatus = "Added"

RV

 

[ksgirl]

That is just what I needed. I was trying to make it more complicated than it really was.....to tell you the truth I was attempting to make it impossible!!!! I knew it was something simple.... my brain just isn't working in the 'simple' mode today! Thanks for your help!