|
tech
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Display all fields that are yes in a table in one boxIm 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. -- Show quotePC Datasheet Your Resource For Help With Access, Excel And Word Applications resou***@pcdatasheet.com www.pcdatasheet.com "Trotsky" <m*@privacy.net> wrote in message news:MPG.1c83238af0c45e82989686@msnews.microsoft.com... > 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 Cheers,
But its setting up the expression that Im having trouble with Thanks In article <s49Sd.2349$Ba3.1***@newsread2.news.atl.earthlink.net>, nospam@nospam.spam says... Show quote > Create a query based on your table and set the criteria for your Issues > filed to Yes. Then base your report on the query. Please explain what you mean by "setting up the expression".
-- Show quotePC Datasheet Your Resource For Help With Access, Excel And Word Applications resou***@pcdatasheet.com www.pcdatasheet.com "Trotsky" <m*@privacy.net> wrote in message news:MPG.1c83511988a60dd8989687@msnews.microsoft.com... > Cheers, > But its setting up the expression that Im having trouble with > Thanks > > > > > In article <s49Sd.2349$Ba3.1***@newsread2.news.atl.earthlink.net>, > nospam@nospam.spam says... > > Create a query based on your table and set the criteria for your Issues > > filed to Yes. Then base your report on the query. > 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. In article <3VnSd.2854$Ba3.1***@newsread2.news.atl.earthlink.net>, nospam@nospam.spam says... Show quote > Please explain what you mean by "setting up the expression". > > -- > PC Datasheet > Your Resource For Help With Access, Excel And Word Applications > resou***@pcdatasheet.com > www.pcdatasheet.com > > > "Trotsky" <m*@privacy.net> wrote in message > news:MPG.1c83511988a60dd8989687@msnews.microsoft.com... > > Cheers, > > But its setting up the expression that Im having trouble with > > Thanks > > > > > > > > > > In article <s49Sd.2349$Ba3.1***@newsread2.news.atl.earthlink.net>, > > nospam@nospam.spam says... > > > Create a query based on your table and set the criteria for your Issues > > > filed to Yes. Then base your report on the query. > > > > > Are you saying that in your table you have Issue1, Issue2, Issue3, etc?
Show quote "Trotsky" <m*@privacy.net> wrote in message news:MPG.1c844e4e19b6ae1e989688@msnews.microsoft.com... > 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. > > In article <3VnSd.2854$Ba3.1***@newsread2.news.atl.earthlink.net>, > nospam@nospam.spam says... > > Please explain what you mean by "setting up the expression". > > > > -- > > PC Datasheet > > Your Resource For Help With Access, Excel And Word Applications > > resou***@pcdatasheet.com > > www.pcdatasheet.com > > > > > > "Trotsky" <m*@privacy.net> wrote in message > > news:MPG.1c83511988a60dd8989687@msnews.microsoft.com... > > > Cheers, > > > But its setting up the expression that Im having trouble with > > > Thanks > > > > > > > > > > > > > > > In article <s49Sd.2349$Ba3.1***@newsread2.news.atl.earthlink.net>, > > > nospam@nospam.spam says... > > > > Create a query based on your table and set the criteria for your Issues > > > > filed to Yes. Then base your report on the query. > > > > > > > > > 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. -- Show quoteDuane Hookom MS Access MVP "Trotsky" <m*@privacy.net> wrote in message news:MPG.1c83238af0c45e82989686@msnews.microsoft.com... > 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 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 It's your choice.
-- Show quoteDuane Hookom MS Access MVP "Trotsky" <m*@privacy.net> wrote in message news:MPG.1c86a3a1f25f65e498968a@msnews.microsoft.com... > 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  |
|||||||||||||||||||||||
Other interesting topics