I have Access database linked table to Excel
And field called date, datatype date ( d,mmm)
it is like written in column 8-jul
Script in VB5
"Select Sum(amount) from TableA Where date between '01-Jul' and '30-Jul'"
Error message 3464 date dype mismatch
Please help to write correct script