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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Selecting Between 2 dates
I actually changed yours and I got it to work WHERE TABLEA_SUMMARY.CAPP_STATUSDATE between #01-09-2002# AND #11-09-2002# I was looking into such complex queries to do this too. Thanks a lot for your help D- ohderek
- Post #6
- Forum: Microsoft: Access Queries and JET SQL
-
Selecting Between 2 dates
Thanx for your help. My MS Acces 97 though says that 'to_date' is an "undefined function" Any other advice please?- ohderek
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Selecting Between 2 dates
I have a very large query running joining many table. I would like to select between 2 dates on a field called "AppStatusDate". The format appears to be giving me problems as it looks like this: '30-09-2002 15:04' Now does anyone know how I can select between say that date and...- ohderek
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
