Fuction NZ

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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)).
 
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

Duane Hookom said:
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
--

Fernando Ríos said:
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
Click to expand...
Click to expand...
 
Back
Top