what is going on with the query

J

JOM

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

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.
 
J

JOM

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!
 
V

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)


JOM said:
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 said:
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.
Click to expand...
Click to expand...
 
Top