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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you specify date ranges in Access? 1
- Thread starter jlp118
- Start date
-
1
- #2
LarryDeLaruelle
Technical User
jlp:
It's pretty straight forward. Use this in your criteria:
>=01/01/00 And <= 12/31/00
This will get you all matching records between the two dates. You'll notice that Access will include pound signs around the dates after you leave the field.
>=#01/01/00# And <= #12/31/00#
That's automatic, you don't need to type them in.
Larry De Laruelle
larry1de@yahoo.com
It's pretty straight forward. Use this in your criteria:
>=01/01/00 And <= 12/31/00
This will get you all matching records between the two dates. You'll notice that Access will include pound signs around the dates after you leave the field.
>=#01/01/00# And <= #12/31/00#
That's automatic, you don't need to type them in.
Larry De Laruelle
larry1de@yahoo.com
- Status
Similar threads
- Locked
- Question