L livvie Registered User. Local time Today, 06:16 Joined May 7, 2004 Messages 158 Aug 12, 2004 #1 I need data for the last 7 days to be returned in a query - how do I do this using the query grid ? I have tried date() - 7 in the criteria column of the date field but it doesn't allow this
I need data for the last 7 days to be returned in a query - how do I do this using the query grid ? I have tried date() - 7 in the criteria column of the date field but it doesn't allow this
A amym New member Local time Today, 00:16 Joined Aug 2, 2004 Messages 6 Aug 12, 2004 #2 In the Criteria box try: Between Date() and Date() -7
L livvie Registered User. Local time Today, 06:16 Joined May 7, 2004 Messages 158 Aug 12, 2004 #3 I'm using Access 2003 and adp and I get the erroe. Date is not a recognised function name.
KenHigg Registered User Local time Today, 01:16 Joined Jun 9, 2004 Messages 13,291 Aug 12, 2004 #4 >= (date() - 7) ??? ken
L livvie Registered User. Local time Today, 06:16 Joined May 7, 2004 Messages 158 Aug 12, 2004 #5 KenHigg said: >= (date() - 7) ??? ken Click to expand... >= (now() - 7) seems to work thanks Ken
L livvie Registered User. Local time Today, 06:16 Joined May 7, 2004 Messages 158 Aug 13, 2004 #6 Pat Hartman said: Make sure that your references are ok. This is a symptom of that problem. Date() is a valid function and is different from Now(). You may get incorrect results if you interject time of day into a date range selection. Click to expand... Sorry Pat what do you mean by my references ?
Pat Hartman said: Make sure that your references are ok. This is a symptom of that problem. Date() is a valid function and is different from Now(). You may get incorrect results if you interject time of day into a date range selection. Click to expand... Sorry Pat what do you mean by my references ?
L livvie Registered User. Local time Today, 06:16 Joined May 7, 2004 Messages 158 Aug 13, 2004 #8 Rich said: http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html Click to expand... Thanks Rich I have 5 references VBA MS 11.o Object Libraru OLE Automation Active X Calendar Whic rtefernce would contain the date function.
Rich said: http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html Click to expand... Thanks Rich I have 5 references VBA MS 11.o Object Libraru OLE Automation Active X Calendar Whic rtefernce would contain the date function.
