Hi,
I have a problem with giving a criteria for a query.
I have experience with BETWEEN and FORMS!FrmName!Control.value in ACCESS but this does not work with Access Project/SQL Server.
I want to give a criteria in a form and with that criteria I want to open a report.
But when I enter a criteria in a query it says: YOU ENTRY CANNOT BE CONVERTED TO A VALID DATE TIME VALUE.
So pls help me.
I have a problem with giving a criteria for a query.
I have experience with BETWEEN and FORMS!FrmName!Control.value in ACCESS but this does not work with Access Project/SQL Server.
I want to give a criteria in a form and with that criteria I want to open a report.
But when I enter a criteria in a query it says: YOU ENTRY CANNOT BE CONVERTED TO A VALID DATE TIME VALUE.
So pls help me.