T trythis Registered User. Local time Today, 05:51 Joined Jul 27, 2009 Messages 67 Sep 5, 2012 #1 query in Access 2010 Between Date() and Date()+1 This worked in 2007 but in 2010 it adds quotes around the 1 and does not work. My dates are date and time so I have not been able to just set date. Thanks, Tina
query in Access 2010 Between Date() and Date()+1 This worked in 2007 but in 2010 it adds quotes around the 1 and does not work. My dates are date and time so I have not been able to just set date. Thanks, Tina
boblarson Smeghead Local time Today, 03:51 Joined Jan 12, 2001 Messages 32,040 Sep 5, 2012 #2 I prefer Between Date() And DateAdd("d", 1, Date())
