This is what is in my Field: Box in my Append Query.
Expr1: [WO End Date]+1
I simply want to add a day onto the WO End Date. Every time I enter [WO End Date]+1 I get the Expr1 added to the start and it simply ignores this part of my query.
I also have another: IIf([Classification]="IMW (FP)","FP",IIf([Classification]="FP","FP",IIf([Classification]="AG","T & M",IIf([Classification]="CO - Contractor","T & M",IIf([Classification]="Contractor","T & M",IIf([Classification]="Agency Temp","T & M","T & M"))))))
Not sure what the deal is with these fields always getting skipped.
Thanks,
Guy