Search results for query: *

Let's say I have a table that looks like the following: Table1: [Name AB Hits] And I have a query that calculates: Avg = Hits / AB But sometimes, the entries in the table have AB = 0. When I run this query, it outputs an error, how can I make it output 0 for Avg if AB = 0 ...

I have a subquery that displays a table similar to this: Query1 -------- [Name,Value1,Value2,Value3] Some of the Value1, Value2 or Value3's are Null values. How can I add up these values treating the Null values as zero? When I try to add a value to null, it returns null. Thanks....

No, actually this comes from another Query. This is an extremely simplified example of what I'm trying to do. I think I can do this with an INNER JOIN ?

Suppose I have the following data that I want to run a Query on: Name: Age: Size: Gender: Bill 10 Mary 20 Bill XL Mary S Bill M Mary F How would I do a...

I have a report that gets it's data from a UNION query that I had to write using SQL statments. My only problem is, when that UNION query is run, for some reason, the fields that I have the format type set to currency loose all their formatting in that query. So when the Report is compiled...

I have a report that gets it's data from a UNION query that I had to write using SQL statments. My only problem is, when that UNION query is run, for some reason, the fields that I have the format type set to currency loose all their formatting in that query. So when the Report is compiled...

Let's say that I have the following 3 tables or quieries that I want to pull data from: Table1: -------- [newproject_name, new_cost] proj1 10 proj2 11 Table2: -------- [continuingproject_name, continuing_cost] proj3 8...

I have a few queries that output some data as shown: query1: --------- [newproject_name, NewProject cost] proj1 10 proj2 11 query2: --------- [continuing_project_name, ContinuingProject_cost] proj3 8 proj4 6 How would I...