Nz Function

[Guest]

I am using the Nz function with a query that is tied to a form. There are currently 11 different fields that can be queried on (1, 2, 3, or none) at any time. However ths Nz funtion does not work with number fields. I need to be able to allow the user to query a currency field (both specific number and ranges). Does any one know how to accomplish this in one query

All my fields (except the one) are text fields. So the user can ask for all records for a certian account, agency, channel, etc. They need to be able to check amounts also.

Did I explain that correctly? Does anyone know of something, that can be used in conjunction with the Nz, to allow this type of query?

 

[Kelvin]

The NZ function will work with numbers. NZ([Field],0) will result in 0 of
[Field] is null. You probably tried NZ([Field],"0"). When you use quotes
it means text regardless of if whats inside the quotes is a number or text.

Kelvin

I am using the Nz function with a query that is tied to a form. There are

currently 11 different fields that can be queried on (1, 2, 3, or none) at
any time. However ths Nz funtion does not work with number fields. I need
to be able to allow the user to query a currency field (both specific number
and ranges). Does any one know how to accomplish this in one query?

All my fields (except the one) are text fields. So the user can ask for

all records for a certian account, agency, channel, etc. They need to be
able to check amounts also.

Did I explain that correctly? Does anyone know of something, that can be

used in conjunction with the Nz, to allow this type of query?

 

[Jeff Boyce]

Stephanie

I don't have a clear picture of your data structure, so ideas on how to
query it are fuzzy. You mention having 11 fields -- do these all contain
the same type of data? (If you had twelve, I would suspect "month"
information, with fields titled "January", "February", ...).

More info, please...

Jeff Boyce
<Access MVP>