Re: Date Criteria

Chris

I'm not clear what you mean by EACH DATE, ALL DATES.

Are you saying you want everything in the same month from last year? If so,
you need the first day of the current month and the last day of the current
month, for the current year - 1.

A shortcut way to get the last day of the current month is to set
DateSerial() to the NEXT month, and the day in DateSerial() to "0" (zero).
The zero'th day of a month is the previous month's ending day.

--
Regards

Jeff Boyce
<Office/Access MVP>

"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AABFEB4C-9EB0-4304-887A-37060AEBAA23@xxxxxxxxxxxxxxxx
> Please help novice.
>
> The following criteria returns LAST year, THIS month, EACH date -
> TO-CURRENT-DATES only.
>
> Between DateSerial(Year(Date())-1,Month(Date()),1) And
DateAdd("m",-12,Date())
>
> I would like it to return LAST year, THIS month, EACH date, ALL DATES.
>
> I cannot figure it out. Please light this darkenss for me.
>
> --
> Thanks for your help,
> Chris

.

Relevant Pages

  • Re: OT - What will Ozzy think now?
    ... > The Chris wrote: ... >> I always remember him saying he wouldn't accept it. ... Is it just politics?? ... Prev by Date: ...
    (rec.music.artists.kiss)
  • Re: My lots in Az.
    ... >> Thanks for saying that. ... >> Take Care ... Prev by Date: ...
    (rec.outdoors.rv-travel)
  • Re: OT:Dentists kit
    ... Bernard Earp wrote: ... it is the way I'm not saying it? ... Chris J Dixon Nottingham ... Prev by Date: ...
    (uk.media.radio.archers)
  • Re: Women in IT
    ... >>> I'm going to have to shut up in a minute, because saying certain things ... >>> in public is probably not the wisest thing to do for a trainee teacher ... Chris ... Prev by Date: ...
    (uk.comp.sys.mac)
  • Re: copyright pop up for photo
    ... > when I tried to save a photo with a right click, ... > usual menu a dialog popped up saying "copyright". ... Chris ... Prev by Date: ...
    (uk.net.web.authoring)