We just converted all our access databases from access97 to access 2000. Now I can't get a query to run from a criteria based upon a date field. Previously if you wanted a date greater than 1/1/2006 you just put >#1/1/2006# in the criteria grid of the query. Any help would be appreciated. Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
converted from access97 to access 2000
- Thread starter rjmdt
- Start date
![[pc2]](/data/assets/smilies/pc2.gif "[pc2] [pc2]")
- Status
Similar threads
- Locked
- Question