I have a database built from form fields in a web form which included a date field that was initially set to a text data type. I can sort with this field but can not perform calculations or use date/time functions. I want to construct a macro or delete query in the Access2000 database that will select all records prior to the current date and delete them. I need a date/time field in order to use the Now() function, so I changed the datatype from text to date/time. This database (part of a web site) is still under development and currently contains all bogus data which will be deleted before going live.
I can not get am Access database query to produce results using now() as criteria in the date field -- 0 records returned even though several entries have been made to the database since changing the data type in the database table, form, etc.
Any idease about how to resolve the problem(s)? All suggestions and comments appreciated.
I can not get am Access database query to produce results using now() as criteria in the date field -- 0 records returned even though several entries have been made to the database since changing the data type in the database table, form, etc.
Any idease about how to resolve the problem(s)? All suggestions and comments appreciated.