Topics Search

query multivalue field for records w/ >1 value

query multivalue field for records w/ >1 value
Views: 81
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:

Similar posts...

 

Creating UpDate Rules for Multivalue fields

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

Missing Check Boxes In Multivalued Fields Icon
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.
 

Append records with attachments

Append records with attachments Icon
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

Append queries records with multivalue fields Icon
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).
 

Getting the sum from a multivalue combobox

Getting the sum from a multivalue combobox Icon
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
 

Creating query to print specific records

Creating query to print specific records Icon
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

changing a records field value Icon
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

Open report with Where Condition from another query Icon
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

Join queries that do not have matching field Icon
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

Queries, Expressions and Text Fields Icon
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.