Re: If Statement

Tech-Archive recommends: Fix windows errors by optimizing your registry

Also, if you are working in a query, you'd be using the IIF() function
rather than an "IF" function.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"cs1954" <cs1954@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:19B91F71-8AB9-4A0B-98EB-E0ACAC947F7A@xxxxxxxxxxxxxxxx
I have a query that projects the next months date "NextMonthDate:
DateAdd("m",1,[Date]). I need to change the date of the projection for
the
month of April on here is what I am proposing

IF [Date] <4/16/06 [Then] NextMonthDate: DateAdd("m",1,[Date]
[ElseIf .4/15/06 [Then] NextMonthDate: DateAdd ("m",1, "d", 4, [Date]
[ElseIf >5/20/06 [Then] NextMonthDate: DateAdd("m",1,[Date]

.

Relevant Pages

  • Re: access date query
    ... "Jeff Boyce" wrote: ... has a start-date less than the date in your production block table. ... Microsoft Office/Access MVP ... Microsoft IT Academy Program Mentor ...
    (microsoft.public.access.queries)
  • Re: Closing a form from another form
    ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ... Microsoft IT Academy Program Mentor ... frmPtDemographicNew I want the frmPatientSearch to close. ...
    (microsoft.public.access.formscoding)
  • Re: sum in a report
    ... Microsoft Office/Access MVP ... Microsoft IT Academy Program Mentor ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.reports)
  • Re: lead zeros appearing in export wizard not notepad text file
    ... Microsoft Office/Access MVP ... Microsoft IT Academy Program Mentor ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.gettingstarted)
  • Re: make combo auto go to item
    ... Microsoft Office/Access MVP ... Microsoft IT Academy Program Mentor ... But in majority of cases the client and the project have corresponding ... "Jeff Boyce" wrote: ...
    (microsoft.public.access.forms)