Display all fields that are yes in a table in one box

  • Thread starter Thread starter Trotsky
  • Start date Start date
T

Trotsky

Hi all,
Im trying to create a report & query that displays a list of fields that
are checked yes in a table,Rather than displaying All the fields and
their status, I would like a text box that only contains only those
fields that are checked.
I hope I'm making myself clear
sort of...

Issues
1,3,4,6

Rather than

Issue 1
Yes
Issue 2
No
Issue 3
Yes
Issue 4
Yes
Issue 5
No
Issue 6
Yes
 
Create a query based on your table and set the criteria for your Issues
filed to Yes. Then base your report on the query.
 
Trotsky said:
Cheers,
But its setting up the expression that Im having trouble with
Thanks
Click to expand...
Put the check box field on the query and use a criteria -1 for checked
(Yes) and 1 for unchecked (No)

gls858
 
I need to know what to put into my query to search through the records
and display those that are checked all within one text box.
I need to put in the critera area of my query something that looks at
issue 1 and decides if it is checked or not and displays it if it is,
looks at issue 2 and decides and so on, so that I get a list.
IE If Issue 1<> 1 then display it.
Im not explaining myself very well.
I understand what I need to do but not how to go about it.
 
I think all responses are heading off in the wrong direction. Your issue
sounds like one of un-normalized tables. Having repeating yes/no columns is
not generally the best solution. I would have a related table of issues
where previously 4 check boxes would be represented by 4 records in a
related table.

For instance assuming you have a table of Loans with a primary key field
[LoanID] and issue Y/N fields being [NoMoney], [FlightRisk], [BeenBankrupt],
[TooOld], and [NoJob]. I would create a lookup table of issues

tblIssues
==============
IssueID autonumber Primary Key
IssueTitle values like No Money, Flight Risk,...

and a table of Loan Issues

tlbLoanIssues
===========
LoanIssueID
LoanID link to tblLoans.LoanID
IssueID link to tblIssues.IssueID

This solution allows you to add more "issues" without changing structures or
objects. You can also create a subreport of LoanIssues that you don't have
to worry about showing the "no" values.
 
Yes,
Each Issue is a separate column in the table and can be Checked yes or
no.
I want to list all issues that are checked yes in a single text/list box
in a form & report.
 
It probably is the most efficient way, but Im so close to finishing the
First Draft Database that Im going to plunge on regardless.
I will try and rebuild it this way for the Second Draft.
Thanks
 
Back
Top