Go Back   Access World Forums > Search Forums

 
Showing results 1 to 6 of 6
Search took 0.28 seconds.
Search: Posts Made By: smilman
Forum: Queries 01-25-2019, 11:12 AM
Replies: 4
Views: 63
Posted By The_Doc_Man
Re: Filter Alpha items in UPC's

CJ's answer is probably easier to code and because it is a built-in inspection function, is likely to be coded efficiently.
Forum: Queries 01-25-2019, 08:43 AM
Replies: 4
Views: 63
Posted By CJ_London
Re: Filter Alpha items in UPC's

suggest use the Like

perhaps something like

Non UPC: IIf([IMMFNO] Like "*[A-Z]*","Non UPC","")

you might find this link useful...
Forum: Queries 01-25-2019, 08:36 AM
Replies: 4
Views: 63
Posted By theDBguy
Re: Filter Alpha items in UPC's

Hi Scott. Not sure if this will work but try something like: WHERE FieldName Like "*[a-zA-Z]*"
Forum: Queries 01-17-2019, 09:01 AM
Replies: 5
Views: 103
Posted By isladogs
Re: Searching for

If the entire field contents are just *, then use . Access will add Like automatically in a query to give Like " "
If it's just somewhere in the text string then use e.g. Like "* *"

Using...
Forum: Queries 01-17-2019, 08:55 AM
Replies: 5
Views: 103
Posted By pbaldy
Re: Searching for

Probably isn't very efficient but one way:

WHERE InStr(1,FieldName,"*")>0
Forum: Introduce Yourself 03-19-2012, 07:43 AM
Replies: 0
Views: 81,120
Posted By Jon
New Member? READ ME FIRST!

Welcome to the Access World Forums!

To get the best out of them, at a minimum I encourage you to do this:

1. Introduce yourself here - not this thread but by clicking the New Thread button -...
Showing results 1 to 6 of 6

 
Forum Jump



All times are GMT -8. The time now is 01:36 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World