Expression Error in "Field" in Design View - I don't get it

[That_Guy]

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

[pbaldy]

Access is simply giving the field a default name since you didn't give it one. You can change it if you want. Did you specify a destination field?

[That_Guy]

Access is simply giving the field a default name since you didn't give it one. You can change it if you want. Did you specify a destination field?

Thanks for the prompt response. I changed it to the following-


Field: WO End Date: [WO End Date}+1
Table: WO TABLE
Append To: New Work Order Start Date


Error that pops up.

Syntax error in query expression '[WO TABLE].[[WO End Date]+1'.


Suggestion?

[pbaldy]

Do you really have the mis-matched brackets, or is that a typo? Also, I wouldn't alias the field with the same name as an existing field; it can confuse Access, as it won't know which you're referring to later.

[That_Guy]

The way I have it typed in with blue text is how it is really typed in. The format when the error windows pops up shows the additional brackets for some strange reason.

[pbaldy]

Try

WOEndDate: [WO End Date]+1