Unique values divide by zero error

[kagard]

Greetings:

I'm using Access 2007. I've created a complex query with a dozen or so calculations. The query runs fine, reports based on it work, too. But if I set the query's Unique Values property to Yes and run it, I get a Divide by Zero error that halts execution of the query.

I thought maybe Access handled the calculations differently in a SELECT DISTINCT query (the result of setting Unique Values to yes), so I created a new query that used the first as its data source. I added all the fields (*) and set Unique Values to Yes in the new query with the same result. I'm puzzled. What am I missing?

TIA

Keith

 

[John W. Vinson]

Greetings:

I'm using Access 2007. I've created a complex query with a dozen or so calculations. The query runs fine, reports based on it work, too. But if I set the query's Unique Values property to Yes and run it, I get a Divide by Zero error that halts execution of the query.

I thought maybe Access handled the calculations differently in a SELECT DISTINCT query (the result of setting Unique Values to yes), so I created a new query that used the first as its data source. I added all the fields (*) and set Unique Values to Yes in the new query with the same result. I'm puzzled. What am I missing?

TIA

Keith

Dunno; could you post the SQL of the query so someone might be able to help?
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com