I am building a query based on status of a item and I am receiving an error that says "data type mismatch in criteria expression."
My query is a basic one, pull the request numbers, the date of the request, who it was assigned to and the status. However, I only want to pull pending requests, so in the criteria field I have it "=Pending" without quotes. What am I doing wrong? This is the sample sql:
SELECT Requests.[Request Number], Requests.[Request Date], Requests.[Assigned To], [Request Status Details New].Status
FROM Requests INNER JOIN [Request Status Details New] ON Requests.[Request Number] = [Request Status Details New].[Request Number]
WHERE ((([Request Status Details New].Status)="Pending"));