[AccessD] Data Type Mismatch in Criteria Expression

I thought it should read:
... Len([ConfigMaster].[PID],-4)


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, October 25, 2011 11:24 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Data Type Mismatch in Criteria Expression

Hi Chester

It should read:

..   Len([ConfigMaster].[PID])-4

/gustav


>>> Chester_Kaup at kindermorgan.com 25-10-2011 18:16:46 >>>
The following criteria generates the data type mismatch in criteria
expression error. The field PID is a text field. What am I missing?

Expr1: IIf(Right([ConfigMaster].[PID],1)="S" Or
Right([ConfigMaster].[PID],1)="L",
Right([ConfigMaster].[PID],Len([ConfigMaster].[PID]-4)),2)

The following works correctly

Expr1: IIf(Right([ConfigMaster].[PID],1)="S" 
Or Right([ConfigMaster].[PID],1)="L",1,2)

Chester Kaup
Engineering Technician
Kinder Morgan CO2 Company, LLP
Office (432) 688-3797
FAX (432) 688-3799

 
No trees were killed in the sending of this message. However a large number
of electrons were terribly inconvenienced.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com