Unable to insert Access queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When trying to use ms-query to import data from an Access database, I've found that it doesn't allow me to open some of the queries (views) from access. It seems that the queries I have trouble importing have the nz() function in calculated fields of the access queries (views) (or in a sub-query). Is this simply not supported or is there a way to work around it?
 
In the Access query, instead of Nz, use an IIF formula. For example:

EstHrsCalc: IIf(IsNull([EstHrs]),0,[EstHrs])
 
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
Can't create a report from my query in Access 1
Not all Access queries can be imported 1
Am I disturbing a machine in production floor if I access its database remotely? 4
Import Data from Access query 8
Import Data from Access 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Access Overflow error 3

Back
Top