PROBLEM
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.
Get help from ArcGIS experts
Download the Esri Support App