如何从Access数据库中获取包含空值的数据

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 errorThanks in advance 解决方案 这篇关于如何从Access数据库中获取包含空值的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！