IIF statement with DCount crashes A2007

[Brad P]

Hoping someone can help me.

I have Access 2007 and a query with a field using this expression:

IIf(DCount("*","Deductions")<30,5,10)

Access crashes every time. Any thoughts?

 

[Gina Whipp]

Brad,

I do not see anything wrong with the below statement. So perhaps providing
the rest of the query will yield some replies that will determine why your
database crashes. With that addiditional information... Is this the only
query that crashes? If you remove this from the query does it still crash?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Jerry Whittle]

What happens when you run just the following?

DCount("*","Deductions")

It should return the number of records in that table.

If that crashes there's a possibility that your database is corrupt. First
make a backup copy then do a Compact and Repair.