Hi
I'm trying to link a spreadsheet to an access database using Microsoft query, and I want it to pull back records based on the date - I know that usually to get a specific date from Access, you enclose it with #, so #10/02/2016#
The problem is, I want to use the wildcard ? and link the parameter to a cell, so that the user can choose the date and the records will refresh accordingly. However, no matter what I try, I keep getting the dreaded "data type mismatch". Here's the query, any help would be appreciated
SELECT tblObservation.Subject, tblObservation.Date, tblObservation.`Overall Rating`
FROM Lesson.accdb.tblObservation
where tblObservation.Date = ?
I'm trying to link a spreadsheet to an access database using Microsoft query, and I want it to pull back records based on the date - I know that usually to get a specific date from Access, you enclose it with #, so #10/02/2016#
The problem is, I want to use the wildcard ? and link the parameter to a cell, so that the user can choose the date and the records will refresh accordingly. However, no matter what I try, I keep getting the dreaded "data type mismatch". Here's the query, any help would be appreciated
SELECT tblObservation.Subject, tblObservation.Date, tblObservation.`Overall Rating`
FROM Lesson.accdb.tblObservation
where tblObservation.Date = ?
