Results 1 to 3 of 3
  1. 05-08-2014, 08:24 AM #1
    Juan4412
    Juan4412 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Dec 2010
    Posts
    209

    IIF Statement In Query


    What would the syntax be to If LEFT(zip,3) = 010 Then Len(zip-3)
    Reply With Quote Reply With Quote
  2. 05-08-2014, 08:50 AM #2
    ItsMe's Avatar
    ItsMe
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    http://msdn.microsoft.com/en-us/libr...ffice.14).aspx
    Reply With Quote Reply With Quote
  3. 05-08-2014, 08:59 AM #3
    burrina's Avatar
    burrina
    burrina is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Freeport,Texas
    Posts
    1,383
    Try this and see if it works, air code!
    IIf(Left("zip",3)="010",Len([zip])-3)
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. if statement in sql statement, query builder
    By 54.69.6d.20 in forum Access
    Replies: 4
    Last Post: 09-11-2012, 07:38 AM
  2. iff statement within a query to create a query by form
    By onemred in forum Queries
    Replies: 3
    Last Post: 07-10-2012, 05:23 AM
  3. query iif statement help
    By swat in forum Queries
    Replies: 4
    Last Post: 09-30-2011, 11:48 AM
  4. Query/IiF statement
    By peacepower in forum Queries
    Replies: 1
    Last Post: 08-23-2011, 04:05 PM
  5. If then statement in query
    By ronnie4 in forum Queries
    Replies: 1
    Last Post: 01-20-2009, 10:49 AM

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