Query Populating Primary key instead of text

[Pfunk11]

I've created an expression to select text from a table, but the expression is populating primary key instead of the text. How do I change the expression to show text?

[JoeM]

I cannot download files from my current location.
Can you post your expression?

[Pfunk11]

Hopefully, you're able to open this via Word doc.

[JoeM]

No, I am unable to download ANY files from the internet, per company security protocol.

[Pfunk11]

Absolutely, the expression is listed below.

Expr1: [qryDJLPlisting].[D] & " " & [qryDJLPlisting].[J] & " " & [qryDJLPlisting].[L] & " " & [qryDJLPlisting].[P]

[JoeM]

What exactly are your "D", "J", "L", and "P" fields?
Are they Combo Box fields? If so, what is their source?
Note that if there source has multiple columns (i.e. and ID value and then a Value), it may be pulling the ID portion.

[Pfunk11]

The "D", "J", "L", and "P" are fields in a table and they are short text data type fields.
I populate the "D", "J", "L", and "P" in the table from a form that uses combo boxes to limit choices for the "D", "J", "L", "P" fields.

[JoeM]

This could be difficult for me to decipher without seeing your database. I should be home in a few hours, and maybe I can download your database then and take a look at it, if no one else gets the chance to do that before then.

[ssanfu]

I populate the "D", "J", "L", and "P" in the table from a form that uses combo boxes to limit choices for the "D", "J", "L", "P" fields.

Are the Row Sources of the combo boxes a Value List or a table/query?

If a Value List, you might have to use the Choose() function to get the text.
If a table/query, add the tables to "qryDJLPlisting", then add the fields that contain the text to the grid instead of the PK field.

[JoeM]

I had mistakenly thought that you attached the database in the first post, but I see it is just a PDF.
If you can post the database, we will be able to analyze it to see exactly what is going on.
Just be sure to remove any sensitive information first.