Hi All,
In MSACCESS, a query by form, Is it possible to select the "And/Or" operator part of a query from a form listbox? maybe using an escape character to prevent the quotations around the selected operator (e.g. "And"
example: the following would be the resulting string that appears in design grid under one column.
[Forms]![frm_name]![frm_combo_box1]+"
[Forms]![frm_name]![listbox_operator_selection]"+
[Forms]![frm_name]![from_combo_box1]
The result of this query would output results based on the value of combo_box1 "and/or" a second value of combo_box1.
would appreciate any suggestions
thanks
ray
In MSACCESS, a query by form, Is it possible to select the "And/Or" operator part of a query from a form listbox? maybe using an escape character to prevent the quotations around the selected operator (e.g. "And"
example: the following would be the resulting string that appears in design grid under one column.
[Forms]![frm_name]![frm_combo_box1]+"
[Forms]![frm_name]![listbox_operator_selection]"+
[Forms]![frm_name]![from_combo_box1]
The result of this query would output results based on the value of combo_box1 "and/or" a second value of combo_box1.
would appreciate any suggestions
thanks
ray