Problems saving amended queries

[J Carvell]

I am having problems saving queries that include the formula to work out the number of working days between 2 dates.

I can view the query, but when I want to save it the whole database closes itself down. Does anyone have any ideas as to why it would do this and how I can stop it happening?

 

[Joe4]

I hate to say it, but it sounds like you *may* have a corrupted database. I would try the following things:

1. Repair the database (Tools | Database Utilities | Compact and Repair Database)

2. If that does not work, try creating a new blank database, and transfer all of your objects over to that one.