If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fuction NZ
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 |
#2
|
|||
|
|||
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" Fernando wrote in message ... 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 |
#3
|
|||
|
|||
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" wrote in message ... 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" Fernando wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Fuction that convert number to English text | oraluck p | Worksheet Functions | 4 | May 13th, 2004 01:30 PM |