Quarterly Restriction
- From: "Leviathan via AccessMonster.com" <u35974@uwe>
- Date: Mon, 10 Dec 2007 21:15:25 GMT
I'm trying to edit the following query that restricts a date field to the
current month, to restrict to the current quarter, any ideas?
=DateSerial(Year(DateAdd("m",-1,Date())),Month(DateAdd("m",-1,Date())),1) And <DateSerial(Year(Date()),Month(Date()),1)
--
Message posted via http://www.accessmonster.com
.
- Prev by Date: Re: Query sort not working after NULL column
- Next by Date: RE: filter for values in another table
- Previous by thread: Convert value to OLE Object
- Next by thread: RE: Quarterly Restriction
- Index(es):
