Recent content by Cassidy7782

  1. C

    Question Help with multiple IIF statements

    I FIGURED IT OUT!!! I just wanted to say thank you all so much for all your help with all of this!
  2. C

    Question Help with multiple IIF statements

    Hahaha I know it has been so long but I have a great excuse... I celebrated the birth of my 3rd child and haven't had as much time as you could imagine. I did implement MajP's structure and have defined StrWhere. I also just implemented the change June7 recommended and table is named "Federal...
  3. C

    Question Help with multiple IIF statements

    Hello again all, I am back at it and have implemented many of the suggestions and placed the values in a table. Now I am encountering a run time error "Run Time Error'3075': Syntax Error(Missing Operator) in query expression" It appears to be in this segment but I am in way over my head...
  4. C

    Question Help with multiple IIF statements

    Thank you all so much for your input. I am self taught with Access and only about a month in. I am using this IIf statement in the text box of a report, which as Galaxiom said is rather backwards. Looks like I need to do more research and imbed the data in a table and pull the applicable fields...
  5. C

    Question Help with multiple IIF statements

    Hello all, I am currently running MS Access 2010 and am having major issues with my multiple if statements. Basically, I have a working set of multiple IIf's and need to have a second set of IIf's based on the value in another field. I did a little research and select may be more applicable but...
  6. C

    Hello from Nick in California

    Hello all, I am very new to MS Access. I am self taught and have been doing so for about 2 months.
Top Bottom