Jeremy Goodman
Last Activity: Mar 4 '11, 01:50 PM
Joined: Feb 10 '11
Location:
-
Went a different, probably cleaner way. As part of concatenation query, placed a column to show Y/N via IIF statement. Now easier to understand data in table and filter. -
Adding Access 2003 version of database (and repost of 2007 version)...Leave a comment:
-
Filtering by Checkbox, concatenated records
I have a Access 2007 database I am testing that has a series of states and check box items that are concatenated to get an overall snapshot response for the state. This concatenates the info as a series of -1 and 0 seperated by commas.
I am trying to set up a form with a check box that generates a report based on a query to filter by the check box response. In this case I have it so that if the check box is checked, it shows all... -
Thank you for the effort, but that really doesn't answer either of my questions. For clarity's sake, the database table consists of the following:
1) State/Territory, Legislation general info (title, date, link to text), specific Legislation information composed of 28 different multiple value comboboxes for various portions of the legislation
2) There are a total of 240 choices from the boxes, usually 5-15 per. Converting...Leave a comment:
-
Since Access uses -1 for yes and 0 for no, would it be possible to add the numerical represenations together when concatenating or instead of merging them? Then the sort could work by using <>0Leave a comment:
-
Additionally, sorting by "No" only yields the record with a single no, not the concatenated records for the state that has two instances of no (0,0). Basically is there any way to modify my code for the function or query so that sorting by "Yes" gives any concatenated record where at least one check box is yes? Thank youLeave a comment:
-
I've run through various methods of fixing this and the most likely fix I saw was the use of Y/N check boxes for each item. This seemed to work in regards to it allowing me to concatenate the records for that item even though it means having way more columns in the tables. Unfortunately, when I was testing it for queries and sorts, I hit a snag. When sorting by "Yes", each new record that is a compilation of 2+ records is filtered as...Leave a comment:
-
Combining multiple rows/records into one
Access 2007; Merging records containing multivalue drop down lists.
I have a database showing legislation information divided by State/territory. The database needs to be able to show the info from each legislation and then an overall picture for the state. There is no problem with merging some of the info using the steps in:
http://bytes.com/topic/access/answer...nto-one-result...
No activity results to display
Leave a comment: