Is This Content Helpful?
We're glad to know this article was helpful.
When using a Microsoft Access table as a join table, the values from the join table return empty in query results. Also, using field names that begin with a number can cause this behavior.
The use of special characters such as as a number sign (#), a period (.), or a quotation mark (") in the field name can lead to this behavior. Using field names that begin with a number can also cause this behavior.
Follow the steps below: