account for error or 0 values

[dharkangel]

Hi,

I have a query that divides two fields on the fly. The problem is that some of these values are throwing errors. One of the columns has this division: 0/2. When I try and create a pivot table from a query it throws an error.

Is there any way to account for these types of things in my query? These fields are updated daily so next week this 0/2 value might be a good value such as 24/7, etc....

thanks again

 

[lespaul]

there's several ways. best one will depend on your query. can you post your SQL?


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[dharkangel]

I figured it out. I used the IIF statement like this:

SELECT FirstQuarterData.WeekDates, IIf(FirstQuarterData.EUM_Week_Total=0,0,FirstQuarterData.EUM/FirstQuarterData.EUM_Week_Total) AS EUM_Weekly_Average.....

thanks.