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.
 
Cheers,
But its setting up the expression that Im having trouble with
Thanks
 
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.
 
Are you saying that in your table you have Issue1, Issue2, Issue3, etc?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checked box automatically checks for subsequent records 7
I have two Yes/No fields in a table (ContractorInstall, andInHouseInstall) 3
Yes/No Display 8
Need report to only select the "yes" based on month 17
Yes/No field check box 4
Yes/No field custom format text color 1
Getting data to appear in tables 1
Importing Text Files Into Access 1

Back
Top