I have a table that contains a number of fields. 5 of these fields are named prop_1 through to prop_5. Also within this table is a src_date field. I have a form that the user selects the date they want and then the prop code they want. For this example I will use the code of 'AC'.
AC could appears in any one of the 5 fields, but not in more than one, and may not appear at all in any of the 5 fields.
How do I create a query that will select data checking across the 5 fields for the value of AC (example only). I was thinking along the lines of
=[Forms]![frm_centre_dashboard]![cmb_sel_centre].[value] & "*"
, but that only seems to work based on one field. I guess the logic is, unless it does not appear in all 5 fields then it returns a zero value. I need it to basically look at each field in turn to see if the value matches, if it doesn't, move onto the next field, does it exist, no, move on, and so on and so forth.
Anybody got any ideas based on that garbage descritpion of what I am trying to acheive.
AC could appears in any one of the 5 fields, but not in more than one, and may not appear at all in any of the 5 fields.
How do I create a query that will select data checking across the 5 fields for the value of AC (example only). I was thinking along the lines of
=[Forms]![frm_centre_dashboard]![cmb_sel_centre].[value] & "*"
, but that only seems to work based on one field. I guess the logic is, unless it does not appear in all 5 fields then it returns a zero value. I need it to basically look at each field in turn to see if the value matches, if it doesn't, move onto the next field, does it exist, no, move on, and so on and so forth.
Anybody got any ideas based on that garbage descritpion of what I am trying to acheive.
Last edited:
