Need help with Division ZERO problem

[lloydanderson]

Hello,

really new at databases - trying to show the value of having a database at work- I have a divide by zero error -
I have about twenty calculations of this type;

[WG Occ Rooms], [WG Room Rev]/[WG Occ Rooms] AS [WG AVG Rate]
In access the results are #ref# but SQl returns divide by zero erro

The default on these colums is zero - how can make this calculation work?

Your help is appreciated.

 

[lloydanderson]

Never mind figured it out:

Case when [CG Occ Rooms] = 0 then 0 else [CG Room Rev]/[CG Occ Rooms] end AS [CG AVG Rate],

As I said, very new to databases...