Syntax Help! Deadline Today! Please help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey all. I am going to post this quick and hopefully get a response back
soon. Any help is appreciated.

IIF([forms]![frm_report_dates]![cbo_source]="Domestic",1,IIf(Len([forms]![frm_report_dates]![cbo_source])>0,2,IIf([forms]![frm_report_dates]![cbo_error_source]=1,1,IIf([forms]![frm_report_dates]![cbo_error_source]=7,[qry_details_I1_filter_dates].[source_id],[forms]![frm_report_dates]![cbo_error_source]))
Or
IIf([forms]![frm_report_dates]![cbo_error_source]=1,2,IIf([forms]![frm_report_dates]![cbo_error_source]=7,[qry_details_I1_filter_dates].[source_id],[forms]![frm_report_dates]![cbo_error_source])))))
 
Maybe this is your answer --
IIF([forms]![frm_report_dates]![cbo_source]="Domestic",1,
IIf(Len([forms]![frm_report_dates]![cbo_source])>0,2,
IIf([forms]![frm_report_dates]![cbo_error_source]=1,1,
IIf([forms]![frm_report_dates]![cbo_error_source]=7,[qry_details_I1_filter_dates].[source_id],[forms]![frm_report_dates]![cbo_error_source]))))

--
KARL DEWEY
Build a little - Test a little


KARL DEWEY said:
What is the question?
--
KARL DEWEY
Build a little - Test a little


PiB311 said:
Hey all. I am going to post this quick and hopefully get a response back
soon. Any help is appreciated.

IIF([forms]![frm_report_dates]![cbo_source]="Domestic",1,IIf(Len([forms]![frm_report_dates]![cbo_source])>0,2,IIf([forms]![frm_report_dates]![cbo_error_source]=1,1,IIf([forms]![frm_report_dates]![cbo_error_source]=7,[qry_details_I1_filter_dates].[source_id],[forms]![frm_report_dates]![cbo_error_source]))
Or
IIf([forms]![frm_report_dates]![cbo_error_source]=1,2,IIf([forms]![frm_report_dates]![cbo_error_source]=7,[qry_details_I1_filter_dates].[source_id],[forms]![frm_report_dates]![cbo_error_source])))))
Click to expand...
Click to expand...
 
Back
Top