Date changes and Access has to close

J

Joey041

Hello,

Just recently, when I do a query and pull records including the date field,
some dates that the records were entered change to the current date. When I
go to run the Report, I get the message that Access has to close. I am
assuming something is corrupted but do you have an idea on how to fix this?
 
N

Nikos Yannacopoulos

Joey,

Any chance you have a table field called Date? If yes, you have to
change it to something else. Date is an Access reserved keyword, so
using it in the wrong context may cause problems - it is actually a
function that returns the current date (as per the system clock), so
this might explain some (if not all) of your problems.

HTH,
Nikos
 
Top