SameFE, Same BE, one a qurey user works fine, another gets "data type mismatch in criteria expression"

[marlan]

Hi all you experts,

I have some software by a client with 2-3 users, each copies the FE to his work station (regular PCs, I have VDI access to the network too), and access the same BE on the LAN (or Virtual LAN). all files are Acc2003 mdb files running in newer Office environments.

part of the process is 7 queries on 7 product price-lists - getting the average, grouped by a category field:

SELECT CategoryID, round(avg(price / nz(QntPacks,1) / nz(QntInPack,1)),4)
FROM PriceList1
WHERE nz(price,0)>0
GROUP BY CategoryID
HAVING CategoryID Is Not Null

These queries have been working fine for years, but now one of them generates the data type mismatch in criteria expression error, In only one work station!

Seems to me like an IT or windows update issue, but the IT says all is up to date.

Any ideas?

 

[Minty]

Despite what IT say, get the full windows and office version numbers from the problem child.
Then compare to a working system.

 

[Ranman256]

what about 64bit vs 32bit? both the same?
what about office versions?

 

[Pat Hartman]

Did you test by using the exact search criteria in both cases?