value from dropdown menu combined with ither text

[lindegaard]

Hello out there

I have made a table with drop down in sokme field and regular shoort text in others. Now in my quary i want to combine does to values of text to becomming one. one dropdown and one short text, but when i use regular "&" i get a number from the drop down and not the text value. the result is like 9Jensen instead of "text"&"text".



Anybody have a solution here or is it impossible?

Kind regards

[ItsMe]

... i get a number from the drop down and not the text value...

That is because the lookup field will store the index of your lookup, not the part that humans care about. The value stored is the ordinal position of the desired element.

Create a copy of your Access database file.

The solution is to not use lookup fields in your tables. Create a separate table. Include a Primary Key column in your new table using the Autonumber field. Create a second column with short text data type to store the description. Now, in your original table, delete the lookup and change the data type to a Number type that uses Long Integer as the Field Size. Use the Number type in your original table as the Foreign Key.

Now you can store the value from the Primary Key field of your second table in the Foreign Key field of your original table. Use a query that joins the PK on the FK to retrieve the relative records of your second table.

[NTC]

your drop down field (probably a look up field) actually binds to the number value that is displaying in your query (even though it displays the text); this is a feature of the look up field type that many developers rant against; although once you understand this it isn't particularly difficult to manage.

in your query you must add the text field to the display results