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

marlan

Registered User.
Local time
Tomorrow, 01:48
Joined
Jan 19, 2010
Messages
409
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, 23:48
Joined
Jul 26, 2013
Messages
10,355
Despite what IT say, get the full windows and office version numbers from the problem child.
Then compare to a working system.
 

Ranman256

Well-known member
Local time
Today, 19:48
Joined
Apr 9, 2015
Messages
4,339
what about 64bit vs 32bit? both the same?
what about office versions?
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 19:48
Joined
Feb 19, 2002
Messages
42,981
Did you test by using the exact search criteria in both cases?
 

Users who are viewing this thread

Top Bottom