To answer the question of why I want to do things in VBA, I found this:
Code:
Temp_Address_1: IIf(DatePart("m",Now())=1 And [Here_Jan]="Y" Or DatePart("m",Now())=2 And [Here_Feb]="Y" Or DatePart("m",Now())=3 And [Here_Mar]="Y" Or DatePart("m",Now())=4 And [Here_Apr]="Y" Or DatePart("m",Now())=5 And [Here_May]="Y" Or DatePart("m",Now())=6 And [Here_Jun]="Y" Or DatePart("m",Now())=7 And [Here_Jul]="Y" Or DatePart("m",Now())=8 And [Here_Aug]="Y" Or DatePart("m",Now())=9 And [Here_Sep]="Y" Or DatePart("m",Now())=10 And [Here_Oct]="Y" Or DatePart("m",Now())=11 And [Here_Nov]="Y" Or DatePart("m",Now())=12 And [Here_Dec]="Y",Null,[Second_Address_Line_1])
for each of the fields Address1, address2, city, state, zip and country. In VBA I can set the current month number and make the test of the "here" fields one time and construct the proper address. Part of this problem is poor database design, but I cannot do anything about that.