If Statement

G

Guest

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]
 
G

Guest

Thanks will give it a try

Jeff Boyce said:
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


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

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


cs1954 said:
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]
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with small result type 2
Fiscal Year Query 1
More than one calculation with between dates 2
Query doesnt work after importing from 97 to 2000 4
DateDiff returning incorrect years 11
"Query too complex" workaround 4
Date Issues - Help! 3
Date Expressions & Calculations 3

Top