G Guest Jan 4, 2005 #1 I am trying to select data in a query that fall between two dates. Can anyone pls help me with a formula. Many thanks in advance!
I am trying to select data in a query that fall between two dates. Can anyone pls help me with a formula. Many thanks in advance!
A Andi Mayer Jan 4, 2005 #2 I am trying to select data in a query that fall between two dates. Can anyone pls help me with a formula. Many thanks in advance! Click to expand... SELECT * FROM MYTable WHERE MyDateFIELD BETWEEN #StartDate# AND #endDate# Start and EndDate have to be mm/dd/yyyy format
I am trying to select data in a query that fall between two dates. Can anyone pls help me with a formula. Many thanks in advance! Click to expand... SELECT * FROM MYTable WHERE MyDateFIELD BETWEEN #StartDate# AND #endDate# Start and EndDate have to be mm/dd/yyyy format
J Jeff Boyce Jan 4, 2005 #3 Sarah Open a query in design mode. Add the field that holds the date. As a criterion under that (date-related) field, use something like: Between #1/1/2004# And #1/31/2004# The "#" signs are NOT optional if you are using actual dates (but Access will insert them if you only type the dates). Check the wide variety of date-related functions to try other values. Use parameters if you want the user to enter dates.
Sarah Open a query in design mode. Add the field that holds the date. As a criterion under that (date-related) field, use something like: Between #1/1/2004# And #1/31/2004# The "#" signs are NOT optional if you are using actual dates (but Access will insert them if you only type the dates). Check the wide variety of date-related functions to try other values. Use parameters if you want the user to enter dates.
