Results 1 to 2 of 2
  1. 04-14-2014, 07:26 AM #1
    Huddle
    Huddle is offline Competent Performer
    Windows XP Access 2010 64bit
    Join Date
    Jun 2010
    Posts
    318

    IIF statement to determine first 6 months of the year


    I want to create an IIf statement that if [Forms]![Fm_Date_Parameter]![EndDate] is before July 1 of any given year then, 1 otherwise, 2. I'd appreciate any help in this.
    Reply With Quote Reply With Quote
  2. 04-14-2014, 08:20 AM #2
    John_G
    John_G is offline VIP
    Windows XP Access 2003
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    Hi -

    iif(month([Forms]![Fm_Date_Parameter]![EndDate]) <= 6,1,2)

    should work for you.

    HTH

    John
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Previous Year and Specified Month in Select statement VBA
    By BLFOSTER in forum Programming
    Replies: 2
    Last Post: 04-15-2014, 08:43 AM
  2. Date Functions to get first three months of year or any 3 consecutive months
    By stevekroll in forum Queries
    Replies: 3
    Last Post: 02-23-2014, 02:06 PM
  3. Need IIf statement to determine Member Eligibility please
    By LukeBourke in forum Access
    Replies: 36
    Last Post: 08-19-2013, 11:38 AM
  4. counting number of used months in each year within a query
    By dmc in forum Access
    Replies: 3
    Last Post: 05-12-2012, 04:52 AM
  5. Calculate number of months between a start date and end of year
    By ErikaMarie0421 in forum Queries
    Replies: 11
    Last Post: 08-04-2010, 04:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums