[AccessD] Query expression

Susan Harkins ssharkins at gmail.com
Mon Nov 9 12:21:31 CST 2020


It's a placeholder for a single digit -- not sure how I'd use it in this
case. 

Susan H 


Doesn't the wildcard "*#*" get anything with a digit

JimB 

-----Original Message-----
From: AccessD <accessd-bounces at databaseadvisors.com> On Behalf Of Susan
Harkins
Sent: Monday, November 9, 2020 6:00 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Query expression

That's what I came up with but as a query expression (grid): 


> Not Like '*1*' And Not Like '*2*' And Not Like '*3*' And Not Like '*4*'
> And Not Like '*5*' And Not Like '*6*' And Not Like '*7*' And Not Like
'*8*'
> And Not Like '*9*' And Not Like '*0*'



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



More information about the AccessD mailing list