How To Display Multivalue Fields

Oct 22, 2012

In my table, I setup a multivalue field. In the screen, I can check off more than one selection. It stores the selections in the table as value1, value2, value3, etc...which is fine. However, when I go back to review the entry in a report or a screen, it displays it exactly the same as it is stored in the table - value1, value2, value3, etc...Because of size limiations, the field is only so wide, thus it only shows value1, va...and then the rest cut off.

Regardless of how wide I make the field, all of the values will not be displayed, plus, if there is only one value, it will be a waste of space. What is the best way to display one (if there is only one selected) or all of the values selected ? Is there a way to display then vertically, like value1, (next line) value2, (next line) value3 ?

View Replies


ADVERTISEMENT

Reports :: Grouping With Information From Multivalue Fields

Feb 6, 2015

I have a table which now contains a couple of hundred records with more than thirty fields each, and will ultimately contain over 1000 records. Some of these fields use the multiple value feature, and the fields and the forms which fill them work beautifully. Now comes the challenge.

Without going into detail that I'm not at liberty to share, I can say that there are different offices which have different people who are responsible in different ways for the work covered in these records. It is possible for each record to have multiple people assigned to it from the same office. This requires setting the control that shows the people from each office to allow multiple values. I need to be able to create a report which will allow me to hand a list of all the records each person is responsible for in the office to the person responsible, in spite of the fact that this will mean records will show up on more than one person's report.

Before I knew that there might be multiple people in the office for each record, I created great reports grouping and ordering by this office's control and field. Now, since they allow and store multiple values, I can't use them any more. I need to be able, as I said above, to get the same effect. I think the answer lies in some sort of calculated field or formula that applies text filters. What I need to be able to do is look in the field for this office and see if a person's name is contained in the field for that particular record, regardless of who else might be in the field, too. I need to be able to use the results from this filter or calculation or formula to generate something I can use in the group and order by processes.

View 7 Replies View Related

Tables :: Similar Option To Multivalue Lookup Fields

Apr 16, 2013

Is there another field that can be used beside the lookup field in an Access table? I am currently using the lookup field as a multivalued lookup field and I am limited to the the things I can do with it when creating a report or a query on that field. Is there a similar field in Access 2010 that has the same look as a lookup field and allows for multiple values to be selected?

View 4 Replies View Related

Query Multiple Tables Using INNER JOIN And Multivalue Fields

Jan 28, 2013

Here is my current table structure (I have omitted some fields from this example and have given some sample data in italics to make the table structure more clear.

tblEmployees

ID (autonumber) 3
EmployeeName John
EmployeePhone 555999555
EmployeeLocation New York

tblClients

ClientID (autonumber) 1 , 2 , 3
ClientName ABC Company , XYZ Company, PQR Company
fkeyLocationID

tblLocations
LocationID 1 , 2
Location New York , Chicago

tblEmployeeClients (junction table)
fkeyID 3
EmployeeClients (multivalued number) 1,2

The junction table tblEmployeeClients only stores ID of the Employee and in the second column (which is a multi-valued field), the ID of each of the clients the employee Supports.

I am trying to generate a report that lists say, EmployeeName alongside the clients supported by the Employee (listing the client location is not required, however, it would be good to know how to do that as well).

The report (for the example above), should look like this:

Name Clients Supported
John ABC Company, PQR Company

Currently, I am able to get :

John 1, 2 i.e the client ID for the clients that the employee supports instead of the corresponding company names.

View 1 Replies View Related

Tables :: Assigning Task Using Multivalue Fields Then Marking Completion

Dec 11, 2013

I have a database which is working ok where i have a set of tasks in a table with a bunch of irrelevant fields. On creation of a task i assign users to those tasks into a multivalue field(this is all fine).

Using a query i can report to each user what tasks they are assigned to easily.

To make the database more complex i would now like to assign these users to a task and then allow them to assign there portion complete (but not the whole task complete) but i can not assign a bool variable to a .value (can i?).

My thoughts are my database is just not set up for this by using the multivalue field to hold the assigned users?

View 1 Replies View Related

Creating Multivalue Field

Dec 19, 2006

Hi Everybody,

I've a question that is teasing me. How would I create a multivalue/multiple answer field in access 2002. P'se forgive if this question has been asked before. Thanks in advance,

Samia

View 9 Replies View Related

Multivalue Criteria Search In Query

Oct 24, 2005

I have a multivalue criteria inside a listbox that I need to use to filter several data out of a table by using a query. The multivalue textfield is the 3rd column of the listbox (eg. John Jonson,Tom Boost,Kim Moore). When I select a row inside the listbox, I want all the adressess of the people that are mentioned in the 3rd column when I click on a button.
How do I make this criteria for a query to get the information I wanted?

View 5 Replies View Related

MultiValue Field Access 2003

Oct 9, 2006

Hi Everyone

I have been working on an access 2003 database for four weeks now and have been asked to create a field in a table that allows a user to select mutliple entries from a list.
This information in this field of a table needs to be able to be queried and reported on in written and graphical reports.

I have tried and hit a brick wall any help with setting this up would be most appreciated.

Thanks

Mish

View 1 Replies View Related

Access 2007 Multivalue Field Ability

Feb 2, 2007

Hi Everyone

In Access 2007, we are able to use a multivalue field, however I don't see the functionality for it anywhere, anyone else notice this??

View 2 Replies View Related

Queries :: Appending Tables With Multivalue Field?

Nov 3, 2014

I have two tables "Tab_Issue_1" and "Tab_Issue_2". Tab_Issue_1 has two fields "Issue" and "AssignedTo". Tab_Issue_2 has the same fields. However, the "AssignedTo" is a multi-value field in both tables. I want to append data from Tab_Issue_1 into Tab_Issue_2. I use the following SQL but it pops up this message "An INSERT INTO query can not contain a multi-valued field".

[SQL]
INSERT INTO Tab_Issues_1 ( Title, AssignedTo )
SELECT Tab_Issues_2.Title, Tab_Issues_2.AssignedTo
FROM Tab_Issues_2;
[SQL]

View 3 Replies View Related

Tables :: Using MultiValue Field Without Making It Lookup

Apr 14, 2014

I've been doing some reading on multivalue fields and it seems to be exactly what I'm looking for. My question: Is there a way to use the multivalue field without making it a lookup? I need the user to be able to put multiple values in a field but can't limit them to a list. The field that needs multiple values happens to be for SKU numbers from a large department store franchise.

One work around I've come up with is to have a pop up that asks for the separate sku numbers so they can be used for the value list each time, but then the user also would have to select those from the value list in order to enter it.... too many end user steps.

I want to avoid making 10-15 different fields each for SKU number, Item, and cost... I also need to avoid having to populate my db with the department store's full list of products...

View 5 Replies View Related

Queries :: Using Or Statement From Multivalue Listbox In Query

Jul 3, 2013

I would like to have the user select one or more values in a list box, and use those values as criteria in a query. Then the query will be used as a source for list boxes in another form based on the values of the previous selection.

Example:

User selects options 1, 3, and 4 from the list box on Form A. The query then sets the criteria to anything related to 1 OR 3 OR 4. Then in another form, Form B, all the data tied to option 1 is in its own list box, all the data tied to option 3 is in its own list box, and all data tied to option 4 is in its own list box.

View 12 Replies View Related

Queries :: Update Query On Multivalue Field

Dec 16, 2013

I have a multivalue field containing values of A,B,C and D with primary IDs of 1,2,3 and 4 in that order.

If I was to run:

Code:
UPDATE Table
Set Table.Multivalue.Value = 1
WHERE Field 1 = "True" AND Field 2 = "True";

Then run

Code:
UPDATE Table
Set Table.Multivalue.Value = 2
WHERE Field 1 = "True" AND Field 2 = "True";

Will I have a Multivalue field as A,B or just B? I would like it to be A,B but I have my doubts as to whether this would work.

View 8 Replies View Related

General :: Creating Entries In A Table Based On Multivalue Lookup

Aug 3, 2014

I am designing a database for a quarry for maintenance of their machines. I have a table that has a full list of all the parts on the machines, and a multiple value lookup field that says what machines said parts are used on. I am trying to have these values translate to another table, so I can then insert a field to say how many of each part are used on the respective machine, to display on an information form for each machine.

I would also like this table to update if the relevant information is updated, for example if a new machine is input, then have the table update to reflect what parts are used on it (an After Update function?) I have made a query that gives me the read out I want (attached) but just cannot figure out how to get that into a table so I can add the extra information.

View 1 Replies View Related

Queries :: Search Multivalue Lookup Field From Form Entry

Sep 20, 2013

I have a form that looks up office names and will automatically populate a field called office number based upon their selection in the combo box. I have a submit button on click event set up to run a query.

Now, here's where I am running into issues: In this query, I need to pull selected columns of information based upon a multivalue lookup field. This multivalue lookup field is joined with the table that the values populate from.

The form will only have one value stored in the txt box field, and I need to be able to search for all records containing that one value.

This is what I have for code:

SELECT FilePlan.FPName, FilePlan.Description, FilePlan.[File Code], FilePlan.GRS, FilePlan.Schedule
FROM Offices INNER JOIN FilePlan ON Offices.[Office Number] = FilePlan.OfficeNumb.Value
WHERE (((FilePlan.OfficeNumb.Value) Like "*" & [Forms]![RetCutOff]![txtOffNumb] & "*"));

Do I need to string multiple queries together to make this work, or is it just not possible?

View 6 Replies View Related

Multivalue List In Table - Displaying Names Separated By Comma

Sep 30, 2011

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 ?

View 5 Replies View Related

Combining Fields For Display

Aug 15, 2006

I have fields lastname, firstname, spousefirstname, spouselastname -

I would like to display:

Koenig, Mark & Jane (not a problem)

- but in some cases the spouselastname is different so then I would like to display:

Koenig, Mark & Jane Doeinger

This is how it displays with my code:

Koenig, Mark & Jane & Doeniger

I can't seem to get rid of the & between the spousefirstname and spouselastname.

Code:SELECT Potentials.Agent, [LastName] & ", " & [FirstName] & IIf([SpouseFirstName] Is Null Or [SpouseFirstName]=""," "," & " & [SpouseFirstName]) & IIf([SpouseLastName] Is Null Or [SpouseLastName]=""," "," & " & [SpouseLastName]) AS Expr1, Potentials.Address, Potentials.City, Potentials.State, Potentials.ZipFROM Potentials;

How do I get rid of the second &

View 5 Replies View Related

Convert Text To Number In Multivalue Table Field Without Data Loss

Oct 21, 2012

I have a multivalue text field called "Groups" that is generated through a relationship with another table called "Comments". When I set this up I left the field as a text field when it should have been a number field, and now I can't use the database with sharepoint, because the field needs to be a number field.

My Question is there a way to convert it without loosing all my data, as there are over 5000 records?

My Table with the multivalue field is called "Contacts", the field is called "Groups".

I tried update and append queries but I must be doing something wrong....

View 2 Replies View Related

Display Fields Based On Number

May 14, 2005

Hi Guys and Girls,

While doing a rabbit DB for the missus I have hit a problem, if one of the does gives birth to 3 babies i wish to have the details entered onto a form (not a problem) but i would like to do this:

if number of babies = 3 then fields to display to enter details is 3 on the form, i have my table setup with up to 10 seperate field for the babies per record but am stuck trying to do this

any help or direction would be great

View 8 Replies View Related

Sort By Three Fields And Display In Form

Aug 2, 2005

Hello folks,

There must be an easy answer to this! I have searched the forums but have not found what I need to make this work the way I want it to. I have a three part reference field. The records in the form are supposed to be sorted into ascending order Field1 first, then Field2 and finally Field3. The forms RecordSource is a query that brings through the relevant fields from my table. I have the query sorted according to these three fields so that every time I open the database it sorts the way I want it to. What I want to do is have a button that will sort the records into the correct order when the buttion is clicked. I am sure this can be done, but cannot get it to work on more than one field at a time! Any help/ideas would be greatly appreciatted.

Thanks

View 1 Replies View Related

Combo Box - Trying To Display Two Fields Unselected

Dec 28, 2005

I am trying to display two fields when the combo box is unselected.

Basically I have a table source manufacturer. This table has Manufacurer e.g. Nokia. Model No e.g. 3230.

So on the combo box i want it to show Nokia 3230. Saves me linking to a subform to show the information.

Can it be done???:)

View 4 Replies View Related

Display Count Of Fields In Form.

Jul 21, 2006

Is it possible to have a count of all records matching a certain criteria displayed on the form?

I have to schedule customers for certain dates but never know how many have been scheduled by date while in the form. I am not sure how to reference the field from the table to be counted. I have several unbound boxes with:

=date()&" "&{XXXX}([SCHEDULE DATE]=date()
=date()+1&" "&{XXXX}([SCHEDULE DATE]=date()+1
=date()+2&" "&{XXXX}([SCHEDULE DATE]=date()+2
etc.

not sure what to use for {XXXX}

As always, any help is appreciated.....

Someday I will contribute some answers instead of questions.....

View 1 Replies View Related

Forms :: Display Table Fields Have No Value

May 30, 2014

I have a from which asks for a date, then displays the records from a table that match that date. On that form, I can make changes. Then I hit a recalculate button which has an EVENT which attempts to manipulate those field names from the table, BUT those field names in a debug.print are coming up blank. How do I get the values from the form/Table to be available to the Event? Probably simple, I'm just not sure how.

View 1 Replies View Related

Display Fields After Listbox Selection

Oct 22, 2014

I have been working on this problem for 3 days, and can't figure out what to do. I'm using Access 2010.

I have two tables. Tier1 and Tier2.

Table: Tier1 has Tier1ID (autonumber) and Tier1Desc

Table: Tier2 has
-Tier2id (autonumber)
-Tier1ID (which is the link back to the Tier1 table),
-Tier2Num -- this number shows which tier2 records are associated with each other
- and about 6 fields with descriptive info, 2 of which are memo fields

I have a form that has 2 listboxes:

- Listbox 1 has the row source to Tier1 table, control source Tier1ID
- Listbox 2 is an unbound listbox with the row source to a query.

The query is all the fields from Tier2 with the criteria where Tier1ID in Tier2 table = Tier1ID in Tier1 table

This all works. When I select something from the Tier1 ListBox, it displays the associated tier2 items for the tier1 selection.

What I need : When the selection is made in the 2nd listbox, I need the other 6 fields in tier2 table to be displayed based on the "Tier2Num". The listbox does return Tier2Num correctly.

I just need to display all the rest of the fields.

- I tried a popup form based on a query, but can't seem to pass the tier2Num to a form. (The query works if you enter the Tier2Num, which is the
[listitem] selection)
- I tried dlookup in a textbox
- I tried to add all the fields into the listbox, but could only get 3 to display (then I was going to do textboxes with the control(#) in it.

View 7 Replies View Related

Display Records When Two OTHER Fields Match

May 20, 2015

I currently have a query that uses a function to get the current users email address. This is matched with a "Teacher Email" address in a table of students to only show students which match the logged in teacher. I'd like to modify this so the teacher can see any student in their department. Is there a way to do this without creating a separate "Teachers" table that would contain a department and email?

View 5 Replies View Related

Queries :: Multivalue Field - Values Revert To Primary Key In Datasheet View When Saved

Dec 23, 2013

A have a query that selects a multivalue field. The query forms the record source for a subform. The text values in the multivalue field are displayed in the query, but when I save this and view the data in the subform datasheet view the values revert to the primary key values. They are 1,2,3,4 instead of the text values

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved