S
scorpio_x73
a have a table with 10 fields (col1,col2,col3...col10) i want to make a
query that will show in a custom field all the data from that fields
example
col1=red
col2-green
col3=blue
in my query i have one custom field with name COLOR when i run the
query i want the field color to show all the colors like
color
red
green
blue
i tried something like this but is not working
color:[col1] or [col2]
it returns a value -1
if anyone can help please
query that will show in a custom field all the data from that fields
example
col1=red
col2-green
col3=blue
in my query i have one custom field with name COLOR when i run the
query i want the field color to show all the colors like
color
red
green
blue
i tried something like this but is not working
color:[col1] or [col2]
it returns a value -1
if anyone can help please