I am getting a "Type mismatch in expression" error when running query using two joined linked Sharepoint datasheets.
One datasheet is "Custodians". It is hosted on a Sharepoint server.
The other datasheet is "BoxTracker". It is also hosted on a Sharepoint server.
The BoxTracker datasheet has a lookup field, titled "Custodian" linked to the "Full Name" field of the Custodians datasheet. This is the only link between the two datasheets in Sharepoint and also in Access as shown in the Relationships view and in the query design view when both tables are shown.
Both datasheets are linked to the MS Access database I am building. I have query that show selected fields from both datasheets.
Whenever I try to run the query I get the "Type mismatch..." error. There is nothing in sharepoint to set the "type" for a lookup field. I would assume that the type would be the same as the filed it was looking up the data from.
Any help would be greatly appreciated. While I don't think this problem is "Extremely Difficult", it is urgent.
Thank you in advance!