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

marlan

Registered User.
Local time
Today, 21:51
Joined
Jan 19, 2010
Messages
401
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:

SQL:
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

AWF VIP
Local time
Today, 19:51
Joined
Jul 26, 2013
Messages
7,570
Despite what IT say, get the full windows and office version numbers from the problem child.
Then compare to a working system.
 

Ranman256

Registered User.
Local time
Today, 14:51
Joined
Apr 9, 2015
Messages
3,644
what about 64bit vs 32bit? both the same?
what about office versions?
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 14:51
Joined
Feb 19, 2002
Messages
30,160
Did you test by using the exact search criteria in both cases?
 

Users who are viewing this thread

Top Bottom