date selection criteria

  • Thread starter Thread starter Alla
  • Start date Start date
A

Alla

I am writing a query in Access2002. Dates in the dastabase
are a time/date stamp in encoded format. I convert
date/time stamp to standart date and time and format it as
short date. Then, in the same query I put a criteria to
search date <[End date], and wouldn't get anything in the
result. Query works fine if I put an actual date instead
of [end date]. It doesn't happen with >[end date].
I've never ran into a problem like this one working in
Access 97. Have to tell that both, Access 97 and Access
2002 were installed on my computer when I got this
problem. Uninstalling Access 97 din't help.
 
1. Is the Table Field actually a DateTime Field?

2. If you ask about Query, please post the SQL String of your Query so that
potential respondent can check.
 
Back
Top