Hi,
I need to create a field in a query that will be a logical "OR" of other fields -- for example, if I have a table with the following structure:
Name
Issue1
Issue2
Issue3
I'd like a query that will return
Name
HasIssues
where HasIssues is True if any of the issues exists, False otherwise.
I don't want to have a field in my table for this, and I know this must be a simple solution, so I'd love some guidance or thoughts on how to do it.
Thanks!
asp
I need to create a field in a query that will be a logical "OR" of other fields -- for example, if I have a table with the following structure:
Name
Issue1
Issue2
Issue3
I'd like a query that will return
Name
HasIssues
where HasIssues is True if any of the issues exists, False otherwise.
I don't want to have a field in my table for this, and I know this must be a simple solution, so I'd love some guidance or thoughts on how to do it.
Thanks!
asp