Unique values divide by zero error


K

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
 
Ad

Advertisements

J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top