Below is a statement I have in a query. Basically I want to bring back the text of FP, NTE or EST if the respective fields are not null. The query runs but I get a -1 in the field.
Hope some one can help if this is possible. Thanks!
Type: ([Fixed Price] Is Not Null) & " FP " Or ([Not to Exceed] Is Not Null) & " NTE " Or ([Estimated Time Expenses] Is Not Null) & " EST "