Formatting Issue

[JohnnyDarkside]

To summarize my issue, I have two spreadsheets I link to a report. Query left joins them and finds differences. In column A are a combination of alpha and alphanumeric codes. For some reason, the report reads the one spreadsheet, but always prompts me to enter a value for the other one.


I've tried C&P just the values without formatting into a spreadsheet, changing everything to text and to general, used =text, creating a pivot table then C&P the values with and without formatting. In access, the field is short text.
Any ideas?

[Bulzie]

Maybe try this. Create querys from each linked spreadsheeet, add all the fields and for SpreedSheet1 ColumnA, use CStr function for that field like this vColumnA: CStr(ColumnA) . Then create 2nd query for SpreadSheet2 ColumnA and do same thing. Then try to link the 2 querys by those fields and see if it gives you data without the prompt.

[JohnnyDarkside]

So I figured it out. I tried making a sub query to pull from that table then link my main to that sub, but still the same issues. Turns out the spreadsheet that was given to me had this hidden space in the header so I used TRIM to remove it and now it works.