query multivalue field for records w/ >1 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
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.!
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.
I wrote application where I need to append records, but cannot append records which include attachments.
I get a message about multivalue fields
Other records do not. I want to make a query that prints the records that do contain data in that specific field.
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
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.