Recent content by swanside

Hello everybody. Can somebody please help me to convert the following statement that acesss a MySQL database into a SQL statement to access a MSAccess Database. I an having trouble with the IFNULL field? Thanks Paul. SELECT Job_No, IFNULL((SELECT sum(Paying_Rate*Working_Hrs) FROM...