Query acting up

J

JOM

I have a query and one of the columns has the following
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 that column to my query and try to save it, it shuts
down access and does not save what I just did..... is there any reason as to
why this could be happening?

Please help!
OJ!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query acting up! 5
Query acting up! 0
Losing information when running a query 4
Calculated Field in Query - Date Format 5
Crosstab query blank fields 2
Access shutting down when accessing saved query 1
"Query too complex" workaround 4
Query the same table three times 0

Top