query multivalue field for records w/ >1 value

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:

Related Topics

Creating UpDate Rules for Multivalue fields
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
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
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
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
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
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
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
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
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
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.


changing a records field value
is it possible to create a query or a macro that will select all records in a certain field (we will call that field x) and then paste them into another field with in the same table. Then input todays date in to every records (field x) column


Open report with Where Condition from another query
I have a report that is based on a query. It displays all of the records in the underlying query. I want to use a Command button on a form to open up the same report using the same underlying query but restrict the records to show only those that match a field in a second query. For instance, in the report there is a field ContactNbr. In the second query, it has another field called ContactNbr. There is a smaller number of ContactNbr's returned in the second query and I only want records in the report based on the ContactNbr's in the second query. I get confused about the difference between a Filter and the Where statement. Using a macro, I've tried using different combinations of Filters and Where statements but I always return zero records


Join queries that do not have matching field
I have multiple queries that I would like to "put the fields next to each other"
each query has the same number of records and only one field
These fields in each query has nothing to do with each other (ie I cannot make a join from them)

I tried putting them in a query next to each other without creating joins but the result was not satisfactory as Access combines their records so if I combine 2 queries and there are 3 records in each query then the resulting query will have 9 records.but I would only need


Queries, Expressions and Text Fields
I have created a query where a field uses this expression:
IIf([Field 1]"" Or [Field 2]"","Answer B") and this works fine.

When I created a new query where I am joining one Query (Query 1) to another Query that has the expression above (Query 2) I used the relationship Include records from Query 1 and only those records from Query 2 where the joined fields are equal (the joined fields are numeric and the are no null values in the joined fields).

When I use the field that has the expression, it applies that expression to all of the records in Query 1 as well as Query 2.


Linking Query?
I basically have a number of records, each record (row) has a field that can identify another record in the database. For example, Record ID 1 has a field that identifies Record ID 5, Record 5 might have an ID that identifes Record 12. Some records will not identify any other records (the field will be null).

Is there a query (or report!) I can make that will show me the records that link. Perhaps so the most current record is at the top and subsequent linking records are beneath it


Create Query With Unique Records
I have a query that is showing records from a table that has many duplicate records. How can I refine the query to only show unique records? There are records that are close to duplicates,but in order to be duplicates they have to have the same data in more than 1 field (9 fields).


combining two queries to create one query
I have two queries: one has numerous fields detailing the sports card I sold. The other query has a field that has a calculation within the 'net price' field that gives me the the total sale price for that card. For both of those queries, they both have the exact same five records.

When I show both tables in creating a new query, there is no line connecting the tables so I believe there is no relationship. However, when I add all the fields I want from query 1 and add all the only one field I need from the other query, it will give me 25 records instead of 5. In essence, it creates an additional 5 records for every one record.

Why does it do this and how do I get it to stop doing this and only show the 5 records


Query on related tables question
Is it possible to run a query on two related tables to return records where the value of a field in the Main table is not null and a value of a different field in the Related table is not null. So by example if I had Table3 and Table4 related by NameID. My desire is to return all records that have a value in the LastName field in Table3 and a value in the City field in Table4. Is this possible? I have a Left Join query that is returning more records than I want to see. In the attached jpeg (JoinQry.jpg) I am desiring only the records that have a red arrow


Query Field = Query Field
My query has (2) calculated fields:

Field 1: ApptDateOnly: DateValue([DateTime])
Field 2: EventDateOnly: DateValue([EventDateTime])

I want my query to return only records where these two fields are equal.

When I reference either field name in a a where criteria - it acts like it is a parameter query seeking input.


Query Field = Query Field
My query has (2) calculated fields:

Field 1: ApptDateOnly: DateValue([DateTime])
Field 2: EventDateOnly: DateValue([EventDateTime])

I want my query to return only records where these two fields are equal.

When I reference either field name in a a where criteria - it acts like it is a parameter query seeking input