Solved Show "no" results

[paul.brisenden]

Guys, i have a subform displayed on a main form that i wish to show every record that has a "NO" response to a question. could someone step by step the query for me at all please?

 

[Gasman]

Not a lot to go on there?

 

[theDBguy]

Is the Subform linked to the main form? If so, do you want to filter it relative to its relationship with the main form?

 

[Ranman256]

make a query where Response = "no"
set that as the query in the subform.

 

[The_Doc_Man]

Paul, your question is to vague - not because of the end goal but because we can't see the path needed to get from point A to point B. There are only about a gazillion ways to structure databases so any answer we give you now is going to be either extremely generic or totally a guess.

 

[paul.brisenden]

i have a Project ID number that links both the subform and the main form. The relationship is set up and working. I have selected the items from the table that i want to display within the query and added "no" within criteria of the field that contains Yes or No.
however, the subform that contains the query does not display any record information other than a NO, all other boxes remain blank

 

[paul.brisenden]

database is attached if anyone does have 5 minutes to show me where im going wrong.

in a nutshell.

i have a form called RESPONSES, within the form (and table) i have a YES/NO selection.
i have created a query that i thought would work (called responses query)
im looking to display a list on the main page of all records within the responses table that have a "NO" selection so that i am able to at a glace see how many items are a NO and what the name of the item is.

Thanks in advance to anyone that can help

 

[Pat Hartman]

You gave us no context. I have no idea what the name of the main form is without opening every form in design view to see if it has a subform named Responses. Also, there is a compile error when I press the first button on the menu. ALWAYS fix compile errors immediately. They can have far reaching effects when you are testing.

If you ONLY EVER want to show items where Responded = "No" then you must replace the table as the RecordSource name with a query that has a Where clause.

And finally, using a yes/no data type is better practice than using text.

 

[plog]

There are no records in Responses with a value of "no" in the Responded field. There are a few that have " No", but you are working with a machine and "no" and " No" are entirely different things to it.

Look very closely at the characters I put in quote marks above. Don't just stop at the capitalization differences--one of them has 2 characters between quotes, the other 3. That's where you went wrong.

Well, actually storing that data in a text field is where you went wrong. There is a Yes/No datatype in Access that you probably should have used for the Responded field.