what is going on with the query

[Guest]

I have a query that when I try to save after updating, closes access does
anyone know why?

 

[Van T. Dinh]

Does the query work?

Possibly corruptions?

Have you tried Compact & Repair the database?

Try also copy the SQL of the Query then re-create the query by pasting the
copied SQL String.

 

[Guest]

This is what I have now after someone helped me change it, but its still
acting up!

followup:
Switch(
[vTracking]![Datecompleted]-[vTracking]![Date]<=2,"Completed<=48",
[vTracking]![Datecompleted]-[vTracking]![Date]>2,"Completed >48",
[vTracking]![Datefollowup]-[vTracking]![Date]<=2,"outstanding<=48",
[vTracking]![Datefollowup]-[vTracking]![Date]>2,"outstanding>48",True,"Not
In Scope")

I have tried to copy the sql statements several times but when I try save or
exit out from the query, Access closes and nothing is updated ot saved.....
It works though gives me what I want to see.... I have tried to compact and
repair the database but its still misbehaving! So am not sure what it the
problem...

OJ!

 

[Van T. Dinh]

There is no point in keeping 2 threads and respondents only waste time
tripping over each other. John Vinson is more than capable of helping you.

Please do not multiple post in the future. Please see:

http://www.mvps.org/access/netiquette.htm

--
HTH
Van T. Dinh
MVP (Access)

This is what I have now after someone helped me change it, but its still
acting up!

followup:
Switch(
[vTracking]![Datecompleted]-[vTracking]![Date]<=2,"Completed<=48",
[vTracking]![Datecompleted]-[vTracking]![Date]>2,"Completed >48",
[vTracking]![Datefollowup]-[vTracking]![Date]<=2,"outstanding<=48",
[vTracking]![Datefollowup]-[vTracking]![Date]>2,"outstanding>48",True,"Not
In Scope")

I have tried to copy the sql statements several times but when I try save or
exit out from the query, Access closes and nothing is updated ot saved.....
It works though gives me what I want to see.... I have tried to compact and
repair the database but its still misbehaving! So am not sure what it the
problem...

OJ!

Does the query work?

Possibly corruptions?

Have you tried Compact & Repair the database?

Try also copy the SQL of the Query then re-create the query by pasting the
copied SQL String.