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...
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...
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...
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...