InStrNZ help!

[Zonie32]

I have 3 databases. They all have the same query. Two of the database work no problem with this function:

InStr(Nz([Enter Products or Hit OK for All],[dbo_FinanceLog].[product]),[dbo_FinanceLog].[product])>0

When I put this string of code into one of the databases I get an error message 'the expression you entered has a function containing the wrong number of arguments'.

What gives? The other 2 db queries work just fine with this code? I tried shutting down and compact and repair and it just won't work.

Any suggestions?

 

[PHV]

Does this db compiles properly ? No missing references ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Zonie32]

I'm not sure of either. I don't know Access very well to understand how to look for this sort of thing. Any suggestions/hints? thanks!