This topic is locked

ASPRunner 5.2 issue with NZ function

7/8/2008 4:34:48 PM
ASPRunnerPro General questions
M
mfred author

I am trying to write an ASPRunner front end for an Access query. Some of the query fields use the nz function like:

Binding1_Subtotal: Nz([Binding1_Qty],0)*Nz([Binding1_UnitPrice],0)

This works exactly as intended when viewing the query in Access but ASPRunner 5.2 will not load the query with the nz function. Plase advise. Thanks in advance

Sergey Kornilov admin 7/9/2008

You cannot use functions like NZ outside of MS Access.
http://www.theserverside.com/discussions/t...thread_id=23239