Working with Data Access Pages with Nz

  • Thread starter Thread starter mac
  • Start date Start date
M

mac

I've bumped into a problem when pulling data out of a Microsoft Access
2000 database. The query I'm using to pull data with uses MS Access'
Nz function to convert null values to 0. Since this is a MS Access
only function I receive an ODBC error when trying to build a FrontPage
Data Access Page using the query in question. I'm curious if anyone
has found a workaround for this?

- Jason
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access #Error & Excel Pivot 0
Access Overflow error 3
MSQuery and NZ() 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
NZ 5
Nz Function 3
#Error while trying to create DateValue in Access 0
Data Access Page changes 5

Back
Top