I have a report that should show all colors except the colors indicated in 5 fields. My filter (found in Report Property Sheet) for the report is this:
color <> DLookUp("color1","tbl_color") and
color <> DLookUp("color2","tbl_color") and
color <> DLookUp("color3","tbl_color") and
color <> DLookUp("color4","tbl_color") and
color <> DLookUp("color5","tbl_color")
The above works but is there a better way to construct this filter?
color <> DLookUp("color1","tbl_color") and
color <> DLookUp("color2","tbl_color") and
color <> DLookUp("color3","tbl_color") and
color <> DLookUp("color4","tbl_color") and
color <> DLookUp("color5","tbl_color")
The above works but is there a better way to construct this filter?