Stuck on Field value in report (1 Viewer)

Hello,
I am having an issue with what is displayed on a report based on a query. I have attached the file so it makes it easier for everyone to understand my issue, I am by no means fluent in Access but trying to get better and understand what is going on and why, in this case I don't understand the why.

If you run the "Receiving by PN Query" and enter "M22273" when asked for a Part Number you'll see 2 locations are listed. My issue is that the Locations are shown as the ID of the "PartLocation" Table, what I want is the Location of that ID shown, what am I missing?

Thanks in advance
Dave

Hello,

I believe I found the issue, Thanks for looking