Topics Search

query multivalue field for records w/ >1 value

query multivalue field for records w/ >1 value
Views: 77
In Access 2010, I have a table that contains a multivalue field. This field can hold from 1 to 7 values. I would like to create a query that would return only those records in which this field holds more than one value.

On a related note, I would like to create a calculated field that returns the number of values each record holds in the multivalue field
Sponsored Links:

More topics

 

Creating UpDate Rules for Multivalue fields

Preview
I have two multivalue fields. One field indicates who should be trained on a particular document/procedure. The second indicates who has not yet been trained on the document/procedure.

So I've successfully created several "variable" queries which will show individualized reports (based on employee selection via combobox/form) showing Individual Training Plan (which shows all documents regardless of training status), Training Overdue, and Training Required (but not overdue).

So with these queries/reports I can track IF an employee has been trained, but not when. I've tried creating before and after update rules which will "audit" the changes made to these two multivalue fields, compare the data before the change and after.

Then depending on the comparison, assign a date when an employee has been unchecked in the "Untrained" field. I will also need the ability to store and display this date for each document/employee in the reports. I keep getting errors saying that multivalue fields cannot be read.!
 

Missing Check Boxes In Multivalued Fields

Preview
I'm sure its something simple, however I have spent 2hrs so far so thought I would post my question.

I have created a multivalue field which allows me to select many names which form s a circulation list for a report. The multivalue drop down works ox in table view, however when I am inform view the dro down is missing the check boxes.
 

Getting the sum from a multivalue combobox

Preview
In my reservations form I have a multivalue combobox(based on a lookup column) which displays the entertainment description(first column) and the entertainment price (second column). The user can select more than one options, how can I show the total of the entertainment price in a text box
 

Getting the sum from a multivalue combobox

Preview
In my reservations form I have a multivalue combobox(based on a lookup column) which displays the entertainment description(first column) and the entertainment price (second column). Theuser can select more than one options, how can I show the total of the entertainment price in a text box.
 

Append records with attachments

Preview
About 2 months)
I wrote application where I need to append records, but cannot append records which include attachments.
I get a message about multivalue fields
 

Append queries records with multivalue fields

Preview
I need to append a number of tables. I make use of an APPEND QUERY and it works fine. BUT, for one part of my application, I need to work with tables which contain multi value fields (Attachments).
 

Multivalue List

Preview
I created a multivalue list in my table. It contains a list of names and a checkbox. I designed the form based on this and am able to check off multiple names. When I go back to look at the table, it stores in each name separated by a comma. So far so good.

When I create a report to display the data, it displays it as 1,2,3.etc., instead of the names separated by a comma.

What do I need to do to display the names
 

Query criteria in linked table

Preview
I'm relatively new to the Access game but amd trying to extract some data from a healthcare database that I have created.

There is the main table with standard/simple data which has a linked table that allows multiple values to be entered. I have created queries that will count how often each individual response has been entered however I want to create a query that tells me how many records have more than one (multi)value selected.

This would mean that in our reporting we could say x% of people have this condition, x% of people have this condition while x% of respondents had more than one condition.

NB. The linked multivalue table has approx 20possible responses while the main table has about 1000 records.
 

Query criteria in linked table

Preview
I'm relatively new to the Access game but amd trying to extract some data from a healthcare database that I have created.

There is the main table with standard/simple data which has a linked table that allows multiple values to be entered. I have created queries that will count how often each individual response has been entered however I want to create a query that tells me how many records have more than one (multi)value selected.

This would mean that in our reporting we could say x% of people have this condition, x% of people have this condition, x% of people have this condition while x% of all respondents had more than one condition.

NB. The linked multivalue table has approx 20possible responses while the main table has about 1000 records
 

Creating query to print specific records

Preview
I have a form containing thousands of records. Is there a way to create a query that will only display the records that contain data in a specific field. For example, some records have data in this one particular field.

Other records do not. I want to make a query that prints the records that do contain data in that specific field.