Replacing Null with 0

[gilagain1]

I am running a basic query and trying to display call totals with ticket totals. My issue is when i don't have Abandon call data for a certain day it wipes out my ticket totals in the query. How do i replace the null with 0? I tried entering the following in the criteria:

Nz([SumOfAbandon Above],"0")



but it doesn't do anything to the results......any suggestions?

[RuralGuy]

Nz([SumOfAbandon Above],0)

[gilagain1]

I tried that as well and it is still not displaying the row of data for the query. Any other suggestioins?

[RuralGuy]

If you post the SQL for your query maybe some SQL guru will see something and offer a suggestion.

[thhui]

Sometimes, your query must be modified to have a common group id so that all data would be displayed even if some data-column is missing.

[CraigDolphin]

Is this a case where there is data in one table, but no data in the related table, causing the unmatched records to be excluded from the set of results?
If so, then you likely need to look into the topic of how to do an outer/left join between the two tables. Access uses an inner join by default which will exclude records without a mtach in both tables.

Or is this where there is a null field in a table causing other fields from that same table to give erroneous results? If so then we're likely to need more details about the tables and the affected fields.