Display only the fields with "Yes"

  • Thread starter Thread starter JNariss
  • Start date Start date
J

JNariss

Hello,

I am trying to create a query which will show only the records that
contain "Yes".

Is this possible or is there an alternative to go about what I am
trying to accomplish?

Here's the story:

I have a table that looks like similar to this:

ACPID ESCID ACP1ECM ACP1US ACP1Canada ACP2ECM ECP2US ACP2Canada
1 20 Yes No No
Yes Yes No
2 34 No Yes Yes
No Yes No
3 35 No Yes No
Yes No No
4 44 No No No
No No Yes
5 45 Yes Yes No
No No No


What I need to do somehow is to generate this table into either a query
or report where I can only see the choices of "yes" for the ID numbers.
The ESCID (Foreign Key)comes from my main table "ESC" and the ACPID is
the Primary Key in this table.

I have a form which a user fills out and selects choices by use of a
checkbox. After the user makes his/her selections they submit the data
and it shows up in the table like my example above.

Well..........because there are so many choices the user can make I
would only like to view the choices of "Yes".

Can this happen and how??

Thanks,
Justine
 
It ap[pears that your data structure is flawed. This appears to be a
one-to-many relationship. You should have a second table that includes the
ACPID and then a second field for the codes (I don't know what you would
call it.) Then you would olny add records to that table where the value is
Yes.




ACPID CODE?
1 ACP1ECM
1 ACP1ECM
1 ACP2ECM
1 ECP2US
2 ACP1US
2 ACP1Canada
2 ECP2US


etc.
 
Back
Top