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
|
|||
|
|||
nz function problem-query to form
I am using the nz function in my queries. The function works at that level.
However, when I try to open the form it won't allow me to. If I take out the nz function everything works fine. Any suggestions |
#2
|
|||
|
|||
nz function problem-query to form
Could be an issue with the data type. Try an IIf() expression instead.
More details and example: http://allenbrowne.com/QueryPerfIssue.html#Nz -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "southbender" wrote in message ... I am using the nz function in my queries. The function works at that level. However, when I try to open the form it won't allow me to. If I take out the nz function everything works fine. Any suggestions |
#3
|
|||
|
|||
nz function problem-query to form
Details, please. In what way are you not allowed to open the form? Do you
get an error message, or what exactly? Is the form bound to the query? How are you using Nz in the query? southbender wrote: I am using the nz function in my queries. The function works at that level. However, when I try to open the form it won't allow me to. If I take out the nz function everything works fine. Any suggestions -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201001/1 |
Thread Tools | |
Display Modes | |
|
|