Hello!
How do I tell a query to not return a field if there is no data in the field for the records. I know it probably has something to do with null but I'm not sure how to phrase the expression.
Thank you, in advance.
Michael
Hello!
How do I tell a query to not return a field if there is no data in the field for the records. I know it probably has something to do with null but I'm not sure how to phrase the expression.
Thank you, in advance.
Michael
Query doesn't work that way. Fields cannot be dynamic (not considering CROSSTAB). Field is either included or not included, can't be conditional.
Can construct a field with expression that will return alternate value if native field is null. But that is still a field in query.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you. I finally accomplished what I was after by creating 3 separate GeneraID_FK fields. Not ideal but it works.Query doesn't work that way. Fields cannot be dynamic (not considering CROSSTAB). Field is either included or not included, can't be conditional.
Can construct a field with expression that will return alternate value if native field is null. But that is still a field in query.
Thank you!