Null to Zero Question?

[cheuschober]

Using Access 2002

Does anyone know (aside from a CByte() or similar conversion function) how to set a null to zero and keep the field as a numeric field?

Currently I'm using this method in select portion of my query and I get my zeroes , but it changes my data type to a text field:

Nz([qry_Name].[FieldName],0)

Concurrently, is there a way to return a count of zero when no records meet the requirements aside from using a lookup table?

Much thanks,
~Chad

 

[llkhoutx]

cint(Nz([qry_Name].[FieldName],0))

Using NZ is correct. Somehow, Access thinks FieldName is a string.