Hi Everyone,
I'm a bit rusty these days on Access & Excel so please bear with me !
I have a simple query in Access where I have a column
Amount: CInt([ab_booking_fee])
When you run the query where there isn't a value it comes back with #ERROR
I therefore used : Amount: CInt(NZ([ab_booking_fee],0))
Which runs perfectly in Access.
My next step is I want to like the data to a pivot table in Excel, but when I try and retrieve the data from this query it comes up with a
Undefined function 'NZ' in expression
Can anyone assist with this ?
Thank you
Paul
I'm a bit rusty these days on Access & Excel so please bear with me !
I have a simple query in Access where I have a column
Amount: CInt([ab_booking_fee])
When you run the query where there isn't a value it comes back with #ERROR
I therefore used : Amount: CInt(NZ([ab_booking_fee],0))
Which runs perfectly in Access.
My next step is I want to like the data to a pivot table in Excel, but when I try and retrieve the data from this query it comes up with a
Undefined function 'NZ' in expression
Can anyone assist with this ?
Thank you
Paul