Prev: Action Query (Append) didn't add records due to key violations.
Next: DSUM Date Criteria
From: John Spencer on 19 Mar 2010 13:27
Glad it seems to work for you. I still would like to know what you were
trying to accomplish.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

seeker wrote:
> thanks guys. it seems to work
>
> "John Spencer" wrote:
>
>> What are you trying to accomplish? I am guessing that it is one of the two
>> criteria below. If not, please describe in words what you are trying to
>> accomplish.
>>
>> This criteria will generate the 1st day of the month before begin date and the
>> next to the last day of the month before begin date.
>>
>> Between DateSerial(Year([Begin Date]),Month([Begin Date])-1,1) and
>> DateSerial(Year([Begin Date]),Month([Begin Date]),1-2)
>>
>> This criteria will generate the 1st day of the month of begin date and the
>> next to the last day of the month of begin date.
>>
>> Between DateSerial(Year([Begin Date]),Month([Begin Date]),1) and
>> DateSerial(Year([Begin Date]),Month([Begin Date])+1 ,1-2)
>>
>>
>> John Spencer
>> Access MVP 2002-2005, 2007-2010
>> The Hilltop Institute
>> University of Maryland Baltimore County
>> .
>>
First  |  Prev  | 
Pages: 1 2
Prev: Action Query (Append) didn't add records due to key violations.
Next: DSUM Date Criteria