Fuction NZ

[Guest]

Good afternoon.

I am using the function NZ to convert numeric fields without value to have a
value zero in a query.
This query is resulting to combine two tables.
I have a problem.
After applying the function NZ to the fields, the fields lose their format
(standard format) and I do not find the way of recovering the format again.

Fernando Rios

 

[Duane Hookom]

What is "their format"? Formats should be applied to values in controls on
forms or reports. Are you expecting something different?

You might need to wrap Nz() inside Val() like Val(Nz([YourField],0)).

 

[Michel Walsh]

Hi,

"if" you still have the query designer in "design" mode available, then
right click on the column defining the new computed expression, and in the
properties, you should see the "format" property that you can specify. Like
Duane mentioned, it is preferable to specify the format at the control level
"where" you use the data.

Hoping it may help,
Vanderghast, Access MVP

What is "their format"? Formats should be applied to values in controls on
forms or reports. Are you expecting something different?

You might need to wrap Nz() inside Val() like Val(Nz([YourField],0)).

--
Duane Hookom
MS Access MVP
--

Good afternoon.

I am using the function NZ to convert numeric fields without value to
have a
value zero in a query.
This query is resulting to combine two tables.
I have a problem.
After applying the function NZ to the fields, the fields lose their
format
(standard format) and I do not find the way of recovering the format
again.

Fernando Rios