Concatenate in a query shows numbers instead of text

[hesca]

Hello experts,



Im a rookie so please forgive my ignorance. I have a query that converts a field into numbers when I try to concatenate it with other fields
I have a query to concatenate fields into a "master code" for my products database. The product is "online courses". So, I have a table with the courses and a separate table to register the languages, as we may include more in the future.

The Language field is a lookup type, grabbing its data from the "languages" table. In order to create the relationship, access stores it as a number.

So, when I pull the field "language" from the "products" table and try to concatenate it with other fields, it shows as a number.

I have this formula:
Coursecode: [Lang] & [GroupCode]

I want it to show: EN001
but instead, it shows this: 1001

How do I make it show the text?

[ranman256]

Are you sure your field [Lang], is the text version, and not the index. (number)?

That formula is correct...its what's in it I cant see.

[pbaldy]

One of the many downsides to using lookup fields. In your query you need to include the language table and use the text field from there.

[hesca]

Nevermind guys, I figured it out. Duh.

To anyone who has this issue, just used key ID fields with the type of data you want to concatenate.

Sorry everyone.