Query acting up!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JOM <JOM@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 16 Jun 2005 12:34:22 -0700

I have a query and its acting up when I add the following column

Followup: IIf([vTracking]![Datecompleted]-[vTracking]![Date]<=2,"Completed
<=48",IIf([vTracking]![Datecompleted]-[vTracking]![Date]>2,"Completed >
48",IIf([vTracking]![Datefollowup]-[vTracking]![Date]<=2,"outstanding<=48",IIf([vTracking]![Datefollowup]-[vTracking]![Date]>2,"outstanding>48","Not
in Scope"))))

Seems like when I add the above column in the query, I am not able to update
and save the query. Why could this be happening?

Please help!
.

Follow-Ups:
- Re: Query acting up!
  - From: John Vinson

Prev by Date: Date Range
Next by Date: Re: Count Function Ignores Null Values
Previous by thread: Date Range
Next by thread: Re: Query acting up!
Index(es):
- Date
- Thread