G gbanks Registered User. Local time Today, 06:51 Joined Feb 9, 2000 Messages 161 Feb 3, 2010 #1 I have a date field in my query for which I only want to pull the last 6 months of data from the current date. How can I do this? Thanks!
I have a date field in my query for which I only want to pull the last 6 months of data from the current date. How can I do this? Thanks!
SOS Registered Lunatic Local time Yesterday, 22:51 Joined Aug 27, 2008 Messages 3,514 Feb 3, 2010 #2 Set the criteria to be: Between DateAdd("m", -6, Date()) And Date()
