Hi Everyone,
I am having an access database with RegistrationNo ,Barcode, VehicleModel, FuelType, RegistrationDate, InsuranceDate and PUCDate columns.
I am trying to execute a query
"select RegistrationNo as RegistrationID, Barcode, VehicleModel, FuelType, RegistrationDate, InsuranceDate, PUCDate from VehicleMaster where cdate(PucDate)>=cdate(format('01-07-2012',"dd-mm-YYYY")) and cdate(PucDate)<=cdate(format('01-07-2012',"dd-mm-YYYY")) order by Barcode"
But i am getting an error "Invalid use of Null" because there is one null value in PUCDate column.
Can anyone help me how to solve this error
Thanks in advance