I am trying to build a query that will put the data of one field into a new field made by the query. Example, the data of is either cancelled or deleted based upon a date of 1/1/99. if it it 1/1/99 then the new field should show cancelled otherwise it should show deleted. I tried to build the expression Completion Status[Completion Date]="1/1/99","Cancelled","Delayed") but I get #error on the query. Any hints???
I forgot to mention that there are other records in that feild that are complete the only ones that need changed are the 1/1/99 and the null records. The null records are the ones that need to say delayed. Any help would be greatly appreciated!!